ORA-12520: Listeners Running on VIP Address in 10g or Newer RAC [ID 342419.1]


In this Document
Symptoms
Cause
Solution
References
——————————————————————————–
Applies to:
Oracle Net Services – Version: 10.1.0.3.0 to 11.1.0.7.0 – Release: 10.1 to 11.1
Information in this document applies to any platform.
This issue is limited to 10g through 11.1.0.7. The issue described here is fixed in 11.2.
Symptoms
The REMOTE_LISTENER parameter is set to an alias which is defined in the Tnsnames.ora file on both the nodes.
In the Tnsnames.ora file , the hostname is defined with proper domain name.
The IP / VIP and hostname are properly defined in the /etc/hosts file on both nodes.
On the server when trying to log on to database using SQL*Plus, you see the following error:
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
Cause
This is due to Unpublished BUG: 4338578 RAC-CRITICAL: INSTANCE DOESN’T USE VIP ENDPOINT TO REGISTER WITH LISTENER.
In any 10g and newer RAC setup, a problem exists where the instances are not registering correctly with the virtual IP address. They’re attempting to register against the physical ip address instead.
Solution
To implement the solution, please execute the following steps:
1. Set LOCAL_LISTENER for each instance in the cluster. Log in as a privileged user and issue:
SQL>Alter system set LOCAL_LISTENER=”(address=(protocol=tcp)(host=your_node)(port=1521))” scope=both sid=”;
Where “your_node” is the VIP for the host where the instance is running and “instance_name” is the unique instance name for this SID.
Issue this statement for all instances in the cluster using the correct values for host and SID.