当前页面位置: » 丰搜网 » 文档中心 » 详细内容
oracle数据库在一台机器配置两个listener
问题：一台机器同时装两套数据库时（实例名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.
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)
)
)
