- Rongsen.Com.Cn 版权所有 2008-2010 京ICP备08007000号 京公海网安备11010802026356号 朝阳网安编号:110105199号
- 北京黑客防线网安工作室-黑客防线网安服务器维护基地为您提供专业的服务器维护,企业网站维护,网站维护服务
- (建议采用1024×768分辨率,以达到最佳视觉效果) Powered by 黑客防线网安 ©2009-2010 www.rongsen.com.cn
 
  
    
| 作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0 | 
问题:一台机器同时装两套数据库时(实例名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) 
  ) 
  )
| 我要申请本站:N点 | 黑客防线官网 | | 
| 专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479 |