问题：一台机器同时装两套数据库时（实例名o8161,o8151)，无法同时启动两个listener，当启动第二个listener时，显示错误。 $ lsnrctl start LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.5.0.0 – Production on 14-SEP-00 09:25:17 (c) Copyright 199
问题：一台机器同时装两套时（实例名o8161,o8151)，无法同时启动两个listener，当启动第二个listener时，显示错误。
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.5.0.0 – Production on 14-SEP-00 09:25:17
(c) Copyright 1998 Oracle Corporation. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
$ oerr tns 1106
01106, 00000, “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.
问题产生原因：
两个实例的LISTENER.ORA中IPC协议的KEY是相同，而一个系统中KEY必须是唯一的.
解决办法：
修改key的值即可。修改后的文件信息：
o8161实例：（没有修改)
# LISTENER.ORA Configuration File:/oracle/dbs/opstemp/szpcac1/network/admin/listener.ora
# Generated by Oracle configuration tools.
冬瓜配音
AI在线配音生成器
66 查看详情
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /oracle)
(SID_NAME = o8161)
)
)
08151实例：（经过修改)
# LISTENER.ORA Configuration File:/ora815/network/admin/listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = TESTo815))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = 1526))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ora8151)
(ORACLE_HOME = /ora815)
(PROGRAM = extproc)
)
)
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/484625.html
微信扫一扫 
支付宝扫一扫 
