修改参数文件 listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home1/oracle9i/product/9.2.0.1/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SID1)
(ORACLE_HOME = /export/home1/oracle9i/product/9.2.0.1/db_1)
(SID_NAME = SID1)
)
(SID_DESC =
(GLOBAL_DBNAME = SID2)
(ORACLE_HOME = /export/home2/product/9.2.0.5/db_1)
(SID_NAME = SID2)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home1/oracle9i/product/9.2.0.1/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SID1)
(ORACLE_HOME = /export/home1/oracle9i/product/9.2.0.1/db_1)
(SID_NAME = SID1)
)
(SID_DESC =
(GLOBAL_DBNAME = SID2)
(ORACLE_HOME = /export/home2/product/9.2.0.5/db_1)
(SID_NAME = SID2)
)
)
转载于:https://blog.51cto.com/cicizz/12470