ORACLE 監聽配置

標籤：

安裝後最開始如下

# listener.ora Network Configuration File: D:\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\oracle\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-DG2ARE7VIAU)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\oracle\app\Administrator

修改增加

# listener.ora Network Configuration File: D:\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\oracle\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )    (SID_DESC =      (GLOBAL_DBNAME=ORCL)      (ORACLE_HOME = D:\oracle\app\Administrator\product\11.2.0\dbhome_1)      (SID_NAME= ORCL)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 123.123.123.123)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\oracle\app\Administrator

本地

BEMIS =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 123.123.123.123)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SID=orcl)    )  )

 

ORACLE 監聽配置