You enjoyed my old trick with https://laurentschneider.com/wordpress/2012/11/tnsping-and-instant-client.html ? you will love this one ❤️
sqlplus -p db01 Local Net Naming configuration file: /usr/lib/oracle/23/client64/lib/network/admin/tnsnames.ora Attempting to contact: (description=(address_list=(address=(protocol=TCP)(host=srv01.example.com)(port=1521)))(connect_data=(service_name=db01.example.com))) Ok (1.143 msec)
Remark: I first posted ping from within sqlplus, but -p is obviously nice. Thanks Beat Ramseier | LinkedIn via Post | LinkedIn