Oracle: Check SSL connectivity

Once connected to the database, to check whether you are connected via TCPS:

SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') as network_protocol FROM dual;

If you are connected via SSL you will get the response

NETWORK_PROTOCOL
----------------
tcps

Leave a Reply