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