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 18.104.22.168 to 10.2.0.5 [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 22.214.171.124.0 - 64bit Production
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 126.96.36.199.0 - Production on 09-JAN-2006 15:34:00
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
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
Instance "<instance2>", status READY/SECONDARY, has 1 handler(s) for this service...
"DEDICATED" established:29 refused:0 state:ready
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