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 9.2.0.8 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 9.2.0.7.0 - 64bit Production
Sun Solaris
Symptoms
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 9.2.0.7.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...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521)))
Instance "<instance2>", status READY/SECONDARY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:29 refused:0 state:ready
LOCAL SERVER
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 |