Facing the below error after setting up SSL on Oracle DB ( Followed Tim Hall's
https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections )
ora-28864 ssl connection closed gracefully
DB Server OS : Windows Server
Oracle DB : 19c Standard Edition
Tried native encryption as suggested you .
Server
SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES128)
Client
SQLNET.ENCRYPTION_CLIENT=REQUIRED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES128)
Still when I query to check if the DB is using TCP or TCPS, it showing TCP.
Try this query instead
SQL> select NETWORK_SERVICE_BANNER from v$session_connect_info where sid = sys_context('userenv','sid');
NETWORK_SERVICE_BANNER
------------------------------------------------------------------------------------------------------------------
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Authentication service for 64-bit Windows: Version 19.0.0.0.0 - Production
NTS Authentication service adapter for 64-bit Windows: Version 2.0.0.0.0 - Production
Encryption service for 64-bit Windows: Version 19.0.0.0.0 - Production
AES128 Encryption service adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Crypto-checksumming service for 64-bit Windows: Version 19.0.0.0.0 - Production
The "sys_context('userenv','network_protocol')" reflects the PROTOCOL setting in tnsnames.ora, not native encryption