tnsping fails with ORA-12560: TNS:protocol adapter error

(Doc ID 2060881.1)

Last updated on SEPTEMBER 28, 2015

Applies to:

Advanced Networking Option - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

tnsping and sqlplus both fail with ORA-12560 when connecting remotely to a DB using a TCPS listener.

In addition, adding sqlnet tracing parameters on the client side had no visible effect whatsoever, even when properly configured for 11g.

Cause

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