ORA-12520: Listeners Running on VIP Address in 10g or Newer RAC
Last updated on JANUARY 22, 2018
Applies to:Oracle Net Services - Version 10.1.0.3.0 to 126.96.36.199.0 [Release 10.1 to 11.1]
Information in this document applies to any platform.
This issue is limited to 10g through 188.8.131.52. The issue described here is fixed in 11.2.
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:
ORA-12520: TNS:listener could not find available handler for requested type of server
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms