RAC Connection Redirected To Wrong Host/IP ORA-12545 [ID 364855.1]
|
|
|
Modified16-APR-2010TypePROBLEMStatusPUBLISHED
|
|
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Net Services - Version: 9.2.0.8.0 to 11.1.0.7.0 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Checked for relevance on 9-APR-2010.
Symptoms
When we try to connect to a RAC service name we sometimes getredirected 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).
ThePMONprocess handles database registration to the local and remote listeners. For remote listeners registrationPMONwill 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 thelocal_listenerdatabase parameter to point to the local VIP address. For the parameter value use either an alias name which contains in theDESCRIPTIONfield only the VIP address or use an explicit connection statement like the following:
alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=<VIP_address>)(PORT=1521))" scope=both sid='instance_name';
Where "instance_name" is the unique instance name. Issue this statement for all instances in the cluster.
TheLOCAL_LISTENERdatabase parameter will givePMONa 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
------------------------------------------------------------------------------
分享到:
相关推荐
radhat el5 安装oracle rac需要用到的包kernel-xen-2.6.18-53.el5.i686.rpm
1. rpm -ivh rlwrap-0.42-1.el7.x86_64.rpm 2. 检查包是否安装上 rpm -qa rlwrap 3. 修改配置文件 vi .bash_profile 增加:alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' alias lsnrctl='rlwrap ...
kernel-PAE-2.6.18-53.el5.i686.rpm,libXp-1.0.0-8.1.el5.i386.rpm,openmotif21-2.1.30-11.EL5.i386.rpm,oracleasm-2.6.18-53.el5-2.0.4-1.el5.x86_64.rpm,xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm,...
radhat el5 安装oracle rac需要用到的包 kernel-debug-2.6.18-53.el5.i686.rpm
oracleasm-2.6.18-128.1.1.el5-2.0.5-1.el5.x86_64.rpm oracleasm-2.6.18-128.1.10.el5-2.0.5-1.el5.x86_64.rpm oracleasm-2.6.18-128.1.14.el5-2.0.5-1.el5.x86_64.rpm oracleasm-2.6.18-128.1.16.el5-2.0.5-1.el5....
oracle rac部署所需要的asm包,oracleasmlib-2.0.8-2.el7.x86_64.rpm
RedHat/CentOS7离线安装Oracle11g_R2_x64所需的依赖包。 rpm -ivh \ mpfr-3.1.1-4.el7.x86_64.rpm \ compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm \ libmpc-1.0.1-3.el7.x86_64.rpm \ libXau-1.0.8-2.1.el7.x86_64....
官方离线安装包,亲测可用。使用rpm -ivh [rpm完整包名] 进行安装
【RAC】 RAC For W2K8R2 安装--RDBMS软件的安装(五).pdf【RAC】 RAC For W2K8R2 安装--RDBMS软件的安装(五).pdf【RAC】 RAC For W2K8R2 安装--RDBMS软件的安装(五).pdf
【RAC】 RAC For W2K8R2 安装--创建ASM磁盘组(六).pdf【RAC】 RAC For W2K8R2 安装--创建ASM磁盘组(六).pdf
oracle rac 安装数据库rac所需的包
本文详细介绍如何讲oracle rac的数据库数据进行迁移备份,配有图文,适合做做实验在再去实践
RHEL7.3或者CentOS7.3安装oracle 安装RAC使用ASM磁盘必备依赖包,亲测可用 kmod-oracleasm-2.0.8-17.el7.3.x86_64
【RAC】 RAC For W2K8R2 安装--操作系统环境配置 (二).pdf
oracle 12c RAC白皮书 rac-wp-12c
oracle 10g rac 程序安装包
bind-9.3.6-4.P1.el5_4.2.x86_64.rpm oracle安装过程中可能会提示你需要安装的依赖包
redhat el5.1安装oracle rac需要用到的几个升级包 kernel-PAE-2.6.18-53.el5.i686.rpm
内附百度网盘连接 ...3:grid infrastructure,用来安装RAC。 4:客户端(Client); 5:Gateway software,透明网关 6:examples, 示例文件安装包; 7:deinstall,Oracle自带的界面化卸载工具;