网络编程 | 站长之家 | 网页制作 | 图形图象 | 操作系统 | 冲浪宝典 | 软件教学 | 网络办公 | 邮件系统 | 网络安全 | 认证考试 | 系统进程
Firefox | IE | Maxthon | 迅雷 | 电驴 | BitComet | FlashGet | QQ | QQ空间 | Vista | 输入法 | Ghost | Word | Excel | wps | Powerpoint
asp | .net | php | jsp | Sql | c# | Ajax | xml | Dreamweaver | FrontPages | Javascript | css | photoshop | fireworks | Flash | Cad | Discuz!
当前位置 > 网站建设学院 > 网络编程 > 数据库 > Oracle教程
Tag:注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,上传,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,Apache,Tomcat,phpmyadmin,Gzip,触发器,socket
数据库:数据库教程,数据库技巧,Oracle教程,MySQL教程,Sybase教程,Access教程,DB2教程,数据库安全,数据库文摘
本月文章推荐
.Oracle 9i的特点.
.Oracle TNSListener服务启动后自.
.Oracle sql 語句分析.
.ORACLE 9I FOR AIX 5L 的安装.
.oracle下导出某用户所有表的方法.
.让我们一起学做业余DBA!.
.甲骨文进行紧急升级 共发布33个补.
.关于lob字段的处理(通过modplsql.
.BorlandC++使用BDE访问Oracle方法.
.Oracle 9i 分析函数参考手册.
.Oracle--毛病篇.
.寻找发展方向 数据分析的5大技术.
.Inside Oracle9i Tablespace Man.
.REDHAT9下安装Oracle9.2.0的成功.
.10gR2使用RMAN恢复临时表空间的增.
.Oracle9i进程的内存占用问题的说.
.全面理解虚拟邮件域.
.Siebel帮助Oracle实现客户数据整.
.实现在ORACLE中移动数据库文件的.
.使用impdp复制Oracle的schema数据.

如何才能在同一台机器配置两个listener

发表日期:2008-2-9


问题:一台机器同时装两套数据库时(实例名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)
  )
  )
  
上一篇:Oracle9i for windows安装1 人气:1154
下一篇:删除a表中和b表相同的数据 人气:572
浏览全部Oracle教程的内容 Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐