ORA-12560 : TNS:protocol adapter error occurred

ORA-12560 Oracle error indicates a high level error that may have happened in the oracle sqlnet or net8 transport layer. The actual error should be identified based on the other messages that oracle has displayed along with the ORA-12560 error message

 

ORA-12560: TNS:protocol adapter error

Cause:  A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower  level transport errors.  For further details, turn on tracing and re execute the operation. Turn off tracing when the operation  s complete.

 

Some known issues with this error are

 

1. ORA-12560  and ORA-12500 during multiple connections to database : Most probably caused by a lack of resources on the unix server. ORA-12500 is thrown when a TNS Listener fails to start a dedicated process

 

Oracle metalink has a very detailed note on this error .. You can access that note in metalink by searching for note : 119008.1