Oracle TNSPING



Share this article :

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

Tags:

Related posts

Oracle init.ora File
Find Last Patches/Upgrade on Oracle
ORA-04031: unable to allocate bytes of shared memory
How to Replace Specific Value in Oracle DB Column
© 2017 ITsiti. All Rights Reserved
Powered by KEEM