ORACLE监听配置及连接字配置

 2009-09-29

1.listener.ora关键配置

SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = yyf.com.cn)
      (ORACLE_HOME = E:/oracle/product/10.2.0/db_1)
      (SID_NAME = yyf)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

2.tnsnames.ora（连接字配置）

YYF =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS =
        (PROTOCOL = TCP)
        (HOST = 127.0.0.1)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = YYF.com.cn)
    )
  )

如果有配置连接字，则

conn scott/tiger@127.0.0.1:1521/yyf.com.cn可以表示成：

conn scott/tiger@YYF