Hi all,
In attempt to encrypt the traffic between an Oracle database and client, I am looking into the SQLNET.ENCRYPTION_SERVER and CLIENT parameters. On the client we have the Oracle client 12.1.0.2.0 installed on Windows. We have different servers, all Windows server 2012R2, with Oracle 12.1.0.2 SE or Oracle 11.2.0.4 SE
When I put SQLNET.ENCRYPTION_SERVER=REQUIRED in the sqlnet.ora file on the 12.1.0.2 database, and nothing in the sqlnet.ora file on the client (so the defaults are being used for SQLNET.ENCRYPTION_CLIENT and ENCRYPTION_TYPES_CLIENT), the connection works. However, on a 11.2.0.4 database, I get a ORA-12537: TNS:connection closed message. I tried different settings of the sqlnet.encryption_server/client, encryption_types_server/client settings in the right sqlnet.ora files, but keep getting this error.
In my sqlnet.log file on the client, I see:
Fatal NI connect error 12537, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=10.13.0.5)(Port=1521)))(CONNECT_DATA=(SERVICE_NAME=DEV)(CID=(PROGRAM=c:\oracle\product\12.1.0\client_1\bin\sqlplus.exe)(HOST=CLIENTNB)(USER=tduin))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 12.1.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 12.1.0.2.0 - Production
Time: 27-MAR-2018 10:19:26
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 507
TNS-00507: Connection closed
nt secondary err code: 0
nt OS err code: 0
I can't find anything on Oracle Support regarding this error. Can anyone help me get in the right direction?