Talk:Tnsping

From Oracle FAQ
Jump to: navigation, search

[edit] Last line?

In the Last line of the result of tnsping is showing something like OK(300 msecs)

what this indicates ?

Strange question - "OK" means it worked and "300 msecs" means it took 300 milliseconds. Frank Naude 10:45, 16 July 2009 (UTC)

[edit] Remove questionable examples

These examples are wrong, and hence removed from the article. My guess is the OP wanted to show the HOSTNAME adapter, but made a hash of it. Please feel free to correct them and move them back to the article. Frank Naude 10:45, 16 July 2009 (UTC)

$ tnsping myDB:1521

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 24-MAY-2007 08:55:13
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:
/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MyDB)))
OK (10 msec)
$ tnsping unknowndb

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 24-MAY-2007 08:55:13
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:
/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = unknowndb)))
TNS-12535: TNS:operation timed out