我的oracle版本为oracle 11.2.0.4
- 找到监听文件listener.ora
监听文件路径是在安装目录下\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN目录下
我的监听文件路径C:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN - 默认的监听文件为(注:不要直接复制,对照修改即可):
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
#(SID_NAME = CLRExtProc)
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_2)
#(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
- 添加监听LISTENER1后,配置文件为:
# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
#(SID_NAME = CLRExtProc)
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_2)
#(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
#(SID_NAME = CLRExtProc)
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_2)
#(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.36)(PORT = 1522))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
-
启动监听命令lsnrctl start 启动监听发现只启动了监听LISTENER
-
如果要启动新建的监听服务则需要是使用命令lsnrctl start LISTENER1
现在我们的两个监听服务就配置好了