Client Connection to RAC Intermittently Fails-ORA-12545 TNS: Host or Object Does not Exist (文档 ID 364855.1)

APPLIES TO:


Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]

Information in this document applies to any platform.

***Checked for relevance on 29-APR-2013***


SYMPTOMS

When attempting to connect to a RAC service name, the connection intermittently fails with an ORA-12545 error:  TNS: Host or object doesn't exist.   The expected behavior is that the connection would be redirected to any of the listener in the cluster where the listener is running on the VIP.  This is normal under RAC Cluster node load balancing.

However, when the server side listener endpoints are not correctly configured OR the client cannot resolve all forms of the VIP hostname, this error can get thrown.

CHANGES

This is likely a new installation of RAC cluster.

CAUSE

Whe LOCAL_LISTENER is not set at all or is not set correctly, PMON can register both the VIP hostname and the physical hostname with the REMOTE_LISTENER.  This is incorrect in RAC but if it does occur, the client can intermittently be routed to a listener endpoint on either of these addresses.  If the client is unable to resolve the physical hostname or even the vip hostname, the connection will fail with ORA-12545.

And important first set is to check the output for :  lsnrctl services <listener_name>

You should not see the physical hostname in the handler information for your RAC instances.   Here's an example of an incorrect lsnrctl services <listener_name> output for a 2-node RAC cluster:

lsnrctl services oracle_rac_listener

Service "oracle.oracle.com" has 2 instance(s).

Instance "orcl1", status READY, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=myphysicalhost1)(PORT=1521))

"DEDICATED" established:326 refused:0 state:ready

LOCAL SERVER


Instance "orcl2", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:394371 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=myphysicalhost2)(PORT=1521))


Here's an example of what it ought to look like when LOCAL_LISTENER is configured correctly:

lsnrctl services oracle_rac_listener

Service "oracle.oracle.com" has 2 instance(s).

Instance "orcl1", status READY, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=myVIP_host1)(PORT=1521))

"DEDICATED" established:326 refused:0 state:ready

LOCAL SERVER


Instance "orcl2", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:394371 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=myVIP_host2)(PORT=1521))


SOLUTION

Log in with privileges to the instance and issue the following commands so that LOCAL_LISTENER is set correctly:


alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=<your_vip_node1>))" scope=both sid='INSTANCE_NAME1';

Do the same for the 2nd instance where host is set to the <vip_host_node2> and the sid is set to the 2nd instance name.

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=<your_vip_node2>))" scope=both sid='INSTANCE_NAME2';


Now the correct address using the VIP hostname will be registered against the listeners in the cluster.

The client should be able to resolve all forms of the VIP host via their /etc/hosts file.  i.e. short name and fully qualified.


设置LOCAL_LISTENER

[oracle@jason2 admin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Nov 22 13:30:46 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> conn /as sysdba

Connected.

SQL> alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=jason2-vip))" scope=both sid='JASON2';

System altered.

SQL>

[oracle@jason1 admin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Nov 22 13:28:52 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> conn /as sysdba

Connected.

SQL> alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=jason1-vip))" scope=both sid='JASON1';

System altered.

SQL>