返回首页

RAC模式下客户端连接的问题ORA-12545

时间:2012-06-04 11:23来源:知行网www.zhixing123.cn 编辑:麦田守望者

处理过程简述:

ERROR:
ORA-12545: 因目标主机或对象不存在, 连接失败

查看lsnrctl监听的服务是否正常,下面的输出表示监听仍然是主机名称,而不是IP地址
 

 

 

$ lsnrctl service LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 06-FEB-2009 10:08:33 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0LOCAL SERVERService "jxsi" has 2 instance(s).Instance "jxsi1", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb1-vip)(PORT=1521))"DEDICATED" established:278549 refused:0 state:readyLOCAL SERVERInstance "jxsi2", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:72 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb2-vip)(PORT=1521))Service "jxsi_XPT" has 2 instance(s).Instance "jxsi1", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb1-vip)(PORT=1521))"DEDICATED" established:278549 refused:0 state:readyLOCAL SERVERInstance "jxsi2", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:72 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=jxdb2-vip)(PORT=1521))The command completed successfully

更换之前确认一下主机名和实例名
 

 

 

SQL> host hostnamejxdb1 SQL> select instance_name from v$instance;jxsi1

更改本地监听为IP地址
 

 

 

SQL> alter system2 set LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP)(HOST = 10.104.0.11)(PORT = 1521))'3 SID = 'jxsi1';

确认是否已经更改成功
 

 

 

SQL> show parameter lis NAME TYPE VALUE------------------------------------ ----------- ------------------------------local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = 10.104.0.11)(PORT = 1521))recovery_parallelism integer 0remote_listener string LISTENERS_JXSI

在另外一个节点上做同样的操作,完成后查看监听是否更换为IP地址
 

 

 

$ lsnrctl service LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 06-FEB-2009 10:25:09 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0LOCAL SERVERService "jxsi" has 2 instance(s).Instance "jxsi1", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.11)(PORT=1521))Instance "jxsi2", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.21)(PORT=1521))"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERService "jxsi_XPT" has 2 instance(s).Instance "jxsi1", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.11)(PORT=1521))Instance "jxsi2", status READY, has 2 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyREMOTE SERVER(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.0.21)(PORT=1521))"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERThe command completed successfully
 

------分隔线----------------------------
标签(Tag):数据库 Oracle Oracle数据库
------分隔线----------------------------
推荐内容
  • 如何安装oracle 10g数据库 oracle 10g安装图解

    特意为大家制作了一份 oracle 10g安装图解 ,这样大家在安装的时候就不会出错了,至于...

  • Eclipse 如何安装Spring IDE支持

    ECLIPSE ARCHIVE离线安装包 SIZE 4.6 springsource-tool-suite-3.8.1.RELEASE-e4.6-up...

  • Eclipse 初始设置图解教程

    一、自动补全 .abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ 二、字体设置 ...

  • idear如何配置JRebel实现热部署

    习惯写PHP之后,发现写JavaEE最蛋疼的是每次修改完代码,需要重启Tomcat服务,当项目...

  • java常用设计模式原型模式及深浅拷贝

    原型模式(Prototype Pattern)是用于创建重复的对象,同时又能保证性能。这种类型的...

  • java中单例模式的4种实现方式

    单例模式(Singleton Pattern)是 Java 中最简单的设计模式之一。这种类型的设计模式...

  • 猜你感兴趣
  • 教育技术学动态
  • 教育技术学论文
  • 理论研究
  • 应用研究
  • 资源收藏
  • 百家观点
  • 英文文献
  • 中国电化教育
  • 电化教育研究
  • 中国远程教育
  • 开放教育研究
  • 现代教育技术
  • 远程教育杂志
  • 现代远距离教育
  • 中国教育信息化
  • 中国信息技术教育
  • 中小学信息技术
  • Flash龙8娱乐官网手机版
  • Photoshop龙8娱乐官网手机版
  • 3DMAX龙8娱乐官网手机版
  • AutoCAD龙8娱乐官网手机版
  • CorelDRAW龙8娱乐官网手机版
  • Matlab龙8娱乐官网手机版
  • 其他龙8娱乐官网手机版
  • .Net龙8娱乐官网手机版
  • Asp龙8娱乐官网手机版
  • Php龙8娱乐官网手机版
  • Jsp龙8娱乐官网手机版
  • Ajax龙8娱乐官网手机版
  • Android教程
  • 其他龙8娱乐官网手机版
  • Word教程
  • Excel教程
  • PowerPoint教程
  • Ubuntu教程
  • 其他教程
  • 课件下载
  • 软件下载
  • 视频教程下载
  • 其他下载
  • 教案大全
  • 试题大全
  • 课件大全
  • 其他大全
  • 人像摄影
  • 风光摄影