oracle 多個例項監聽不到

mrhaozi發表於2010-02-25

開啟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)
)
)

[@more@]ora

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16396910/viewspace-1031436/,如需轉載,請註明出處,否則將追究法律責任。

相關文章