windows中oracle配置多个监听程序

我的oracle版本为oracle 11.2.0.4

1. 找到监听文件listener.ora
   监听文件路径是在安装目录下\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN目录下
   我的监听文件路径C:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN
2. 默认的监听文件为(注:不要直接复制，对照修改即可):

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

4. 添加监听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

5. 启动监听命令lsnrctl start 启动监听发现只启动了监听LISTENER
   

6. 如果要启动新建的监听服务则需要是使用命令lsnrctl start LISTENER1
   
   现在我们的两个监听服务就配置好了