ORA-12520 After Adding a New Node to a Cluster as Hosts File has 127.0.0.1 Mapped to non-localhost
Last updated on OCTOBER 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
After adding a new node to a cluster, getting the below error when connect to this node.
ORA-12520: TNS:listener could not find available handler for requested type of server
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.oracle.com)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac2)
$lsnrctl services LISTENER_NODE2
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Service "rac" has 2 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
"DEDICATED" established:111 refused:0 state:ready
Instance "rac2", status READY, has 1 handler(s) for this service...
"DEDICATED" established:0 refused:0 state:blocked <<<<<<<<<<<<<<<<
The state of the service 'rac' for instance rac2 is "blocked".
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