Name

tnsping

Use tnsping to determine whether an Oracle Net service can be successfully reached. If tnsping can successfully connect from a client to a server, it displays an estimate of the round trip time it takes to reach the specified Oracle Net service.

Syntax

tnsping net_service_name [count]

Parameters

net_service_name

Specifies a net service name you want to test a connection to. Alternatively, you can specify a protocol address instead of a net service name to test connectivity to an Oracle Names server or Connection Manager instance.

[count]

Specifies a count to repeatedly test the connection.

Examples

The following example pings the listener associated with the net service name TEST10G1 three times:

$ tnsping TEST10G1 3

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 14-AUG-2004 18:08:05

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

Used parameter files:
/oracle/product/10.1.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = pe4slab1)(PORT = 1521))) (CONNECT_DATA =
 (SERVICE_NAME = TEST10G1.mishra.com)))
OK (10 msec)
OK (0 msec)
OK (0 msec)

Get Oracle Utilities Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial