Windows平台配置Oracle多个监听

1 打开服务器net manager
添加新的监听器，注意不要与原来的监听器端口冲突，其实是修改listener.ora文件
关闭窗口以保存配置，但此时不会开始新的侦听

2  新添加的监听需要通过命令创建
lsnrctl start 创建新的侦听名称，新的侦听将出现在服务列表中。开始
此时可以telnet端口测试，可以连接，但与plsql客户端连接后，会提示
侦听器当前无法识别连接描述符中请求的服务

3 我们还需要注册关联、静态注册示例

修改listener.ora文件
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldb)
(ORACLE_HOME = /u01/app/oracle/product/11.2.3/oracle)
(SID_NAME = orcldb)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.15)(PORT = 1521))
)

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldb1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.3/oracle)
(SID_NAME = orcldb)
)
)

LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.15)(PORT = 1522))
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldb2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.3/oracle)
(SID_NAME = orcldb)
)
)

LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.15)(PORT = 1523))
)

然后重新启动侦听服务

sid_name 是安装过程中的实例名称，plsql连接可以 hostname/sid_name 连接
global_dbname 定制各种监控，客户端NetManager配置“服务命名”时，"服务标识->服务名"就是这个
参考
http://blog.itpub.net/30150152/viewspace-1479571/
https://blog.csdn.net/lyjiau/article/details/52238997