Vb教程 Vb.net教程 Vfp教程 C/C++教程 Vc/Vc++教程 Delphi教程 Java教程 Powerbuilder
  杀毒频道 | 短信频道 | 网络电视 | 论文中心 | 学上网 | 学软件 | 网页特效 | 电脑基础 | 论坛  
  NCRE | 软考 | CET | 职称英语 | 司法考试 | 报关员 | 公务员 | CATTI | CPA考试  
  Html教程 | Css教程 | Xml教程 | Asp教程 | Asp.net | Php教程 | Jsp教程 | Linux教程 | QQ技巧  
Photoshop Illustrator ImageReady Maya教程 3D Max教程 Lightscape Coredraw教程 Authorware Autocad教程 Freehand教程
Access教程 Mysql教程 Sql server Oracle教程 Word教程 Excel教程 Powerpoint Frontpage Asp.net源码 Php源代码
Flash教程 Fireworks Dreamweaver C#教程 outlook教程 系统安装 vbscript教程 Javascript Jsp源代码 Asp源代码
您的位置:首页 >> Oracle教程 >> 正文

Oracle数据库在一台机器配置两个listener

文章来源:中国php联盟

  问题:一台机器同时装两套数据库时(实例名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)
   )
   )

[返回]

编程语言 web开发 数据库 网络技术 操作系统 服务器 网页设计 图形设计 办公软件 常用软件 学电脑

Copyright© www.bianceng.cn Powered by 编程入门网 All Rights Reserved.
关于本站 | 版权声明 | 联系我们 | 友情链接 |
编程入门网 版权所有