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)