今天看了飞总的一个博客,针对一台主机上有多个版本的数据库,导致其中一个数据库无法启动,监听不兼容,虽然一个9i的数据使用的是1522,10g的数据库的端口使用的1521,但是
数据监听不兼容ipc冲突,需要注释了一个
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
# )
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =
/u01/oracle/9
.2.0
/db_1
)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = xifenfei)
(ORACLE_HOME =
/u01/oracle/9
.2.0
/db_1
)
(SID_NAME = xff)
)
)