数据读取中...
 您当前位置:惠州维修 -> 网络-> 数据库技术交流-> Oracle 文章搜索:  
Oracle数据库在一台机器配置两个listener
作者:转载 来源:惠州维修
日期: 2006-11-20
放大字体显示 缩小字体显示 打印文章 推荐给朋友
问题:一台机器同时装两套数据库时(实例名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)
  )
  )



文章页数:[1] 
帮助你我他: 1.我有问题请教 2.我要投稿>>>
更多相关资料搜索:
热点文章
最新文章
相关文章
版权申明:除部分特别声明不要转载,或者授权本站独家播发的文章外,大家可以自由转载本站的原创文章,但原作者和来自本站的链接必须保留(非本站原创的,按照原来自一节,自行链接)。文章版权归本站和作者共有。
转载要求:转载之图片、文件,链接请不要盗链到本站,且不准打上各自站点的水印,亦不能抹去本站水印。
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有。
发表评论  打印  刷新  推荐给朋友  返回顶部  关闭

网上大名: