TNSPING is a command to check the Oracle Net connectivity. From the result, you can verify that the connection is working fine to the database.
> tnsping SID 5 TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 00:14:11 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: /oracle/SID/112_64/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP)(HOST = itsiti)(PORT = 1234)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID))) OK (30 msec) OK (0 msec) OK (10 msec) OK (0 msec) OK (0 msec)
Note:
5 : ping 5 times
