About

tnsping is an utility to verify that the net service name are resolved and find in the tnsnames.ora

Articles Related

Example

C:\Documents and Settings\gerardnico>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 20-OCT-2009 07:01:53

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE10G)(PORT = 1521)))
 (CONNECT_DATA = (SID = ORCL)) )
OK (30 msec)