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
- UNIX (Solaris)
TNS Ping Utility for Solaris: Version 10.1.0.5.0 - Production on 15-JAN-2013 14:02:42Copyright (c) 1997, 2003, Oracle. All rights reserved.Used parameter files:/oracle/Ora10g/network/admin/sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting 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:42Copyright (c) 1997, 2003, Oracle. All rights reserved.Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oraserv1)(PORT=1521))OK (200 msec)