TNS-12560: TNS:protocol adapter error

导读：

The error "TNS-12560: TNS: protocol adapter error" is usually related to a configuration issue with the listener:

TNS-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 is complete.

The "TNS-12560: TNS:protocol adapter error" sometimes a transient error on a SQL*Net (Oracle*Net) client, happening sporadically. To turn-on tracing for the ORA-12560, use these settings.  Also check /var/log/messages (Linux) for errors:
 

TRACE_LEVEL_<> = admin
TRACE_DIRECTORY_<> = <>
TRACE_TIMESTAMP_<> = true

Possible fixes for the TNS-12560 include:

1 - Get the latest patches for the SQL*Net client software.

2 - Check your $ORACLE_HOME and $PATH variables

3 - Check file permissions on the PC client

4 - Ensure that TNS_ADMIN is set properly

5 - Check for network firewall issues

6 - In Windows, Verify that the database service is started.  ?Verify that the ORACLE_SID parameter is correctly set in the registry.

本文转自
http://www.dba-oracle.com/t_tns_12560_protocol_adapter_error.htm