Oracle的监听配置

listener.ora的内容：

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))
  )

ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\dbhome_1\log

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
      (SID_NAME = DBname)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (GLOBAL_DBNAME= DBname)
  )
)

再使用

lsnrctl stop

lsnrctl start

tnsnames.ora的内容：

ORACLENAME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 服务主机名或IP)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBname)
    )
  )