OBIEE 11g: "TNS-12560: TNS: Protocol adapter error" Message When Executing tnsping

(Doc ID 2268874.1)

Last updated on APRIL 10, 2018

Applies to:

Business Intelligence Reporting and Publishing - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

You are trying to use the tnsping to verify the connectivity to a database.  However, the command returns this error message:

Attempting to contact  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<hostname>)(CONNECT_DATA=(SERVER=SHARED (SERVICE_NAME=<service_name>)))  TNS-12560: TNS: Protocol adapter error

Changes

 Upgraded to 11.1.1.9 or enabled SSL for the database connection.

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