SSL Connection to 12c DB from Forms or Reports 12c Results in ORA-12560: TNS:protocol adapter error
Last updated on DECEMBER 06, 2017
Applies to:Oracle Forms - Version 18.104.22.168.0 and later
Oracle Reports Developer - Version 22.214.171.124.0 and later
Oracle Net Services - Version 126.96.36.199 and later
Information in this document applies to any platform.
Sqlnet SSL authentication has been set up to a 188.8.131.52 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 184.108.40.206.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.
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