动网论坛,站长建站首选,国内使用量最多的论坛软件 动网论坛官方技术讨论区 站长工具 申请属于您自己的免费论坛
首页 | 新闻资讯 | 网站运营 | 网络编程 | 数据库 | 服务器 | 网页设计 | 图像媒体 | 网络应用 | 搜索优化 | 资源下载 | 动网主机 | DVBOX
    本站内  互联网 ASP论坛  ASP.Net论坛  PHP论坛
   数据库 → 阅读文章
  

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

作者来源: 
阅读 1371 人次 , 2006-3-18 11:53:00 

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

)

)



 本文Tagsoracle  
 收藏本文  打印本文  论坛讨论  关闭窗口
· 上一篇:如何保持Oracle数据库的优良性能
· 下一篇:在UNIX服务器上设置Oracle8i全文检索(1)
· Oracle9i初始化参数中文说明(1)
· SQL脚本生成的一些BUG(1)
· 循序渐进学习Power Builder 6.0(2-6)
· 精通数据库系列之入门-技巧篇4
· Mysql字段长度


关于本站 | 联系我们 | 业务合作 | 客户案例 | 诚聘英才 | 广告合作 | 收藏本站
海口动网先锋网络科技有限公司版权所有
Copyright © 2000 - 2006 Cndw.Com
中华人民共和国电信与信息服务业务经营许可证编号 琼 ICP 020077