The output from tnsping will include a listing showing the
time required to connect to the remote database.
542 Oracle Database 11g DBA Handbook
For example, to determine if the Oracle database on your Linux server identified by the dw
service name in your local tnsnames.ora file is accessible from a Windows client, use the tnsping
command as follows:
C:\> tnsping dw
TNS Ping Utility for 32-bit Windows:
Version 11.1.0.4.0 - Beta on 08-AUG-2007 21:39:42
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
C:\app\Administrator\product\11.1.0\client_1\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.95)(PORT=1521)))
OK (0 msec)
C:\>
Note how tnsping under Windows used Easy Connect to obtain the TCP/IP address of the
server dw, filled in default values, and located the Oracle instance DW on the Linux server
successfully.
In addition to tnsping, you can use the trcroute utility to discover the path a connection takes
to a remote database. The trcroute utility (similar to the Linux utility traceroute) reports on the
TNS addresses of every node it travels through and reports any errors that occur. The command
format is as follows:
trcroute net_service_name
In client/server communications, the same principles for debugging connection problems
apply. First, verify that the remote host is accessible; most communications software for clients
includes a telnet or ping command.
Pages:
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812