I use ODBC connections to link to Oracle databases. These connections use a TNS Name in their Service Name field.
Can I simply PING these TNS Names as a simple connectivity test to the database?
At the COMMAND PROMPT, type:
TNSPING (SPACE and then the SERVICE NAME without the prefix: or the .suffix)
If trying to ping tns:rtkinst.world, your command line should look like:
APPLIES TO / KEY WORDS
Open Database Connectivity