SSL Connection to 12c DB from Forms or Reports 12c Results in ORA-12560: TNS:protocol adapter error (Doc ID 2304830.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Forms - Version 12.2.1.0.0 and later
Oracle Reports Developer - Version 12.2.1.0.0 and later
Oracle Net Services - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Sqlnet SSL authentication has been set up to a 12.1.0.2 DB using steps from the following notes:

<Note 1381035.1> Configuring SSL Authentication With Client Certificates Signed By The Server Using orapki

<Note 736510.1> SSL Step by Step Guide To Configure SSL Authentication

When attempting to connect with FMW 12.2.1.2.0 Forms, Reports, sqlplus, etc., the connection fails with: 

ERROR:
ORA-12560: TNS:protocol adapter error

This error will occur also with tnsping or any executable in the Fusion Middleware (FMW)  Forms and Reports 12c ORACLE_HOME/bin that uses a sqlnet connection.

If tracing for TNSPING is added to the sqlnet.ora file:

The TNSPING trace will show:

ntzCreateCipherSpec: no valid cipher suites were specified.
ntzCreateCipherSpec: failed with error 552
ntzCreateCipherSpec: exit
ntzConfigure: failed with error 552
ntzConfigure: exit
ntzCreateConnection: failed with error 552
ntzCreateConnection: exit
ntzdisconnect: entry
ntzFreeNTZData: entry
ntzFreeNTZData: exit
nttdisc: entry

 

Changes

 Problem did NOT occur until an SSL connection was configured on the FMW client side.

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