What is TNSPING command in Oracle?

TNSPING command is used to check the Oracle Net connectivity. Using this command you can verify if you are able to connect to an Oracle Database successfully or there is some connection issues.

How to run TNSPING Command?

Open command prompt.

Type TNSPING

e.g:

If Successful, a message like below will be displayed:

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 05-JAN-2
011 15:00:52

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

Used parameter files:
C:\ORACLE\product\10.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (enable = broken) (LOAD_BALAN
CE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXXXX)(PORT = 1525)
) (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXXXX)(PORT = 1525)) (CONNE
CT_DATA = (SERVICE_NAME = XXXX)))
OK (2610 msec)

The last line, i.e. OK (2610 msec) signifies that the connection to Oracle server is fine.
If the last line contains an error message, then there is some connection issues. You need to check and fix it.

This is how you can diagnose an oracle Database connection using TNSPING Command.

For Dotnet Projects and Interview Questions, Click here.
For more tips and tricks on Oracle, click here.