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 06, 2017
Applies to:Oracle Forms - Version 126.96.36.199.0 and later
Oracle Reports Developer - Version 188.8.131.52.0 and later
Oracle Net Services - Version 184.108.40.206 and later
Information in this document applies to any platform.
Sqlnet SSL authentication has been set up to a 220.127.116.11 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 18.104.22.168.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!