My Oracle Support Banner

Ora-12520/12516 Received When Listener on Node 1 is Down in RAC Setup. (Doc ID 357882.1)

Last updated on FEBRUARY 20, 2020

Applies to:

Oracle Net Services - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.

RAC instances configured with Primary and Secondary option.
This issue is not relevant to versions newer than 10gR2.
Oracle9i Enterprise Edition Release - 64bit Production
Sun Solaris


When using a TAF connect string in a primary/secondary RAC environment. SQL*Plus throws an ORA-12520 when the listener  is down on  node1.

ORA-12520: TNS:listener could not find available handler for requested type of server

Attempting to connect directly to node 2 via its own listener fails with TNS-12516

The LSNRCTL Services output shows the following:    
    LSNRCTL for Solaris: Version - Production on 09-JAN-2006 15:34:00
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    Service "<service.domain>" has 2 instance(s).
      Instance "<instance1>", status READY, has 1 handler(s) for this service...
          "DEDICATED" established:0 refused:0 state:ready
             REMOTE SERVER
      Instance "<instance2>", status READY/SECONDARY, has 1 handler(s) for this service...
          "DEDICATED" established:29 refused:0 state:ready
             LOCAL SERVER


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

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