发现一台机器中同时运行多个Oracle实例时。。。

来源：互联网发布：内存溢出 java 编辑：程序博客网时间：2024/06/05 08:57

发现一台机器中同时运行多个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)
    )

-----------
)