RAC Connection Redirected To Wrong Host/IP ORA-12545

摘自metalink的文档:

Subject: RAC Connection Redirected To Wrong Host/IP ORA-12545
Doc ID: Note:364855.1 Type: PROBLEM
Last Revision Date: 24-JUN-2006 Status: MODERATED

In this Document
Symptoms
Cause
Solution
References

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to: Oracle Net Services - Version: 9.0.1.4 to 10.2.0.3
This problem can occur on any platform.

Symptoms
When we try to connect to a RAC service name we sometimes get redirected by the first node's listener to the public address/hostname of the second node instead of its VIP address. An ORA-12545 error may be generated if that public hostname is not configured in DNS.

We were expecting the connection to eventually be redirected to the VIP of the other node.

Cause
The Database on one RAC node remote registers with the wrong local IP address to the listener on the other RAC node (e.g. the public IP address instead of the wanted VIP address).

The PMON process handles database registration to the local and remote listeners. For remote listeners registration PMON will have to find out what is the IP address of the local system in order to present it to the remote listener as database contact address.

In the default Oracle configuration, for hosts which have more than one IP address configured on the network interfaces, it is undefined which IP address will be selected for remote registration.

Solution
Modify the local_listener database parameter to point to the local VIP address. For the parameter value use either an alias name which contains in the DESCRIPTION field only the VIP address or use an explicit name like the following:

local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = ) (PORT = 1521))'
The local_listener database parameter will give PMON a hint in respect of which IP address it should use for remote registration with other nodes' listener(s).

References
Note 235562.1 - Issues affecting Automatic Service Registration
Note 256275.1 - Dynamic Registration Fails On Multiple Network Interface Server

Errors
ORA-12541 TNS:no listener
ORA-12545 Connect failed because target host or object does not exist

时间: 2024-10-25 21:41:38

RAC Connection Redirected To Wrong Host/IP ORA-12545的相关文章

virtualbox-xshell为何频频遭遇Connection closed by foreign host

问题描述 xshell为何频频遭遇Connection closed by foreign host 最近,我在做nodejs开发网站,网站需要在家庭win8系统中进行调试,于是,我看了极客学院的nodejs视频资料,开始自己搭建Windows下的nodejs开发环境. 具体的过程如下,我就简单说一下吧,现下载Centos7,Xshell5, Xftp,VirtualBox等软件,还有Git Bash,然后,安装了VirtualBox虚拟机以后,再安装Centos7,这样算是linux虚拟机完成

【RAC】11g R2 RAC新特性之Highly Available IP(HAIP)

[RAC]11g R2 RAC新特性之Highly Available IP(HAIP) 在Oracle 11.2.0.2之前,私网的冗余一般是通过在OS上做网卡绑定(如Bond等)来实现的,从Oracle 11.2.0.2版本开始推出HAIP(Highly Available Virtual IP)技术替代了操作系统层面的网卡绑定技术,功能更强大.更兼容.HAIP通过其提供的独特的169.254.*网段的IP地址实现集群内部链接的高可用及负载均衡.所以,在11.2.0.2或更高版本安装RAC的

The authenticity of host 'IP' can't be established:ssh客户端登录Linux系统出错解决记录

问题 在用ssh客户端第一次登录远程Linux的时候通常会报如下的错误 The authenticity of host 'IP' can't be established. ECDSA key fingerprint is SHA256:+9UZGqPe/Rdaiz9jTg0P5ZtGMl6gVP0i+iPTh8sHwt4. Are you sure you want to continue connecting (yes/no)? Host key verification failed.

【mysql】远程程序调用报错HOSt ip is not allowed to connect t

报错:1130-host ... is not allowed to connect to this MySql server 解决方法: 1. 改表法. 可能是你的帐号不允许从远程登陆,只能在localhost.这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,把user=root的"localhost"值改为"%".

【RAC】failed to online diskgroup resource ora.GI.dg

ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)" [ID 1060920.1] 现象: If OCR is located on ASM diskgroup, following shows in ASM alert log ($ORACLE_BASE/diag/asm/+asm/+ASMn/tr

SSH:Connection closed by foreign host

以为和防火墙,性能,HOSTS.DENY,端口之类的有关,后来查了下,啥都没有关系. 就是同一台机器NAT之后,被另一台抢了先机. http://blog.sina.com.cn/s/blog_6d06f0bf0100wijb.html

MySQL集群的flexAsynch测试工具的安装和使用

一.编译安装flexAsynch Oracle官方推荐的MySQL Cluster性能测试工具有DBT2,flexAsynch等.此处采用了flexAsynch,它是一种非常好的NDB测试工具.由于Oracle并不提供flexAsynch的二进制文件下载,仅仅在MySQL Cluster的源码包中提供这个测试工具的源码,所以必须手动编译MySQL Cluster才能获得flexAsynch的执行文件.以下命令都是在RHEL 6.4中以root账户权限运行. 1. 下载 cd /root/Down

【RAC】如何修改RAC SCAN IP

   在11gR2中,引入了SCAN(Single Client Access Name)的特性,该特性的好处在于,在数据库与客户端之间,添加了一层虚拟的服务层,就是所谓的scan ip以及scan ip listener,在客户端仅需要配置scan ip的tns信息,通过scan ip listener,连接后台集群数据库.这样,不论集群数据库是否有添加或者删除节点的操作,均不会对client产生影响.当有客户端应用程序使用SCAN ip访问数据库时,scan listener会将连接转发到l

What is SCAN in Oracle 11g R2 RAC

What is SCAN in Oracle 11g R2 RAC Single client access name (SCAN) is meant to facilitate single name for all Oracle clients to connect to the cluster database, irrespective of number of nodes and node location. Until now, we have to keep adding mult