发现一台机器中同时运行多个Oracle实例时,最好保证 [OracleHome]/network/admin/listener.ora 文件的 SID_LIST_LISTENER 段中 要对应每个实例都有一段声明
其实这是个很简单的问题,呵呵,只是偶以前一直没留意过,今天刚刚发现。
例如
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = housename)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:/oracle/ora92)
(PROGRAM = extproc)
)
--就是在这里,最好为每个实例有对应的一段
(SID_DESC =
(GLOBAL_DBNAME = Ora1)
(ORACLE_HOME = d:/oracle/ora92)
(SID_NAME = Ora1)
)
(SID_DESC =
(GLOBAL_DBNAME = Ora2)
(ORACLE_HOME = d:/oracle/ora92)
(SID_NAME = Ora2)
)
-----------
)