Documentation Center

tnsping

The tnsping utility verifies SQL Net connectivity between two machines. Use it to troubleshoot SQL Net connections.

To check if the Oracle listener is listening, at a UNIX or Windows prompt, type:

Oracle_home/bin/tnsping service

where Oracle_home is the directory where Oracle is installed and service is the Oracle SID.

For example: c:/ora/bin/tnsping oraserv1

For example: $ORACLE_HOME/bin/tnsping oraserv1

Sample system response:
  • UNIX (Solaris)

    TNS Ping Utility for Solaris: Version 10.1.0.5.0 - Production on 15-JAN-2013 14:02:42

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

    Used parameter files:

    /oracle/Ora10g/network/admin/sqlnet.ora

    Used TNSNAMES adapter to resolve the alias

    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rosie)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraserv1)))

    OK (20 msec)

  • Windows

    TNS Ping Utility for 32-bit Windows: Version 10.1.0.5.0 - Production on 15-JAN-2013 14:02:42

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

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oraserv1)(PORT=1521))

    OK (200 msec)