打开listener.ora修改SID_LIST_LISTENER 部分，例子如下，改完重启监听
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME =orcl)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =orcl)
)
(SID_DESC =
(GLOBAL_DBNAME =orcl2)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =orcl2)
)
(SID_DESC =
(GLOBAL_DBNAME =orcl3)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =orcl3)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16396910/viewspace-1031436/ ，如需转载，请注明出处，否则将追究法律责任。
