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 184.108.40.206.0 and later
Oracle Reports Developer - Version 220.127.116.11.0 and later
Oracle Net Services - Version 18.104.22.168 and later
Information in this document applies to any platform.
Sqlnet SSL authentication has been set up to a 22.214.171.124 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 126.96.36.199.0 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
ntzConfigure: failed with error 552
ntzCreateConnection: failed with error 552
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