|
问题一台机器同时装两套数据库时（实例名oo)无法同时启动两个listener 当启动第二个listener时显示错误 $ lsnrctl start LSNRCTL for IBM/AIX RISC System/: Version Production on SEP :: (c) Copyright Oracle Corporation All rights reserved TNS: Listener using listener name LISTENER has already been started $ oerr tns Listener using listener name %s has already been started // *Cause: Another listener is already listening on one of the ADDRESSes // specified // *Action: Shutdown the previous listener specified by the listener name // before starting this one 问题产生原因 两个实例的LISTENERORA中IPC协议的KEY是相同而一个系统中KEY必须是唯一的 解决办法 修改key的值即可修改后的文件信息 o实例（没有修改) # LISTENERORA Configuration File:/oracle/dbs/opstemp/szpcac/network/admin/listenerora # Generated by Oracle configuration tools LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = )) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = )) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = /oracle) (SID_NAME = o) ) ) 实例（经过修改) # LISTENERORA Configuration File:/ora/network/admin/listenerora # Generated by Oracle Net Assistant LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = TESTo)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = )) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ora) (ORACLE_HOME = /ora) (PROGRAM = extproc) ) ) |
