Can you ping a TNS Name?

=========
QUESTION
———
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?

 

=========
ANSWER
———
Yes 

At the COMMAND PROMPT, type:
TNSPING (SPACE and then the SERVICE NAME without the prefix: or the .suffix)

 

=========
EXAMPLES
———
If trying to ping tns:rtkinst.world, your command line should look like:
tnsping rtkinst

 

=========
APPLIES TO / KEY WORDS
———
Oracle
ODBC
Open Database Connectivity
Connection
Ping

 

=========
REF
———

 


http://www.anysitesupport.com/can-you-ping-a-tns-name/
http://anySiteHosting.com

By | 2017-12-01T23:47:37+00:00 September 19th, 2011|Computers, Documentation, Microsoft, ODBC, Oracle|0 Comments