My Oracle Support Banner

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 DECEMBER 09, 2021

Applies to:

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


Sqlnet SSL authentication has been set up to a 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 Forms, Reports, sqlplus, etc., the connection fails with: 

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



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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.