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

TNS-01190: user not authorized to execute the requested listener
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-04031: unable to allocate bytes of shared memory
Certain files which need to be reinstalled by Oracle UI are being used
© 2018 ITsiti. All Rights Reserved
Powered by KEEM