在一台机器配置两个listener(Oracle)

时间： 2021-07-31 作者：daque

题目：一台呆板同新装两套数据库时（范例名o8161,o8151)，没辙同声启用两个listener，当启用第二个listener时，表露缺点。$ lsnrctl startlsnrctl 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 110601106, 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 assistantlistener =(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)))

在一台机器配置两个listener(Oracle)

相关推荐

推荐下载

热门阅览

最新排行