My Oracle Support Banner

ORA-12520: Listeners Running on VIP Address in 10g or Newer RAC (Doc ID 342419.1)

Last updated on MARCH 31, 2022

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:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.