tnsping utility and timeout

From: <ctippur_at_gmail.com>
Date: Fri, 8 Feb 2013 20:52:53 -0800 (PST)
Message-ID: <3dcb7542-3c62-40a2-8154-a2467f4d8b93_at_googlegroups.com>

Hello,

[Quoted] I am trying to glean connection string from the output of tnsping utility. From our development environment, we dont have acl's open to the database. Couple of questions regarding tnsping utility and its output.

1. Is there a connection time out I can set for tnsping utility? As the connection takes a while
2. Here is the output of tnsping. The weird thing is when I try to parse this output, during situations where the connectivity is a issue, the program hangs and I only see is

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 08-FEB-2013 20:15:25

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

---

The same when tun from command line, I get $ tnsping net_service_name

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 08-FEB-2013 19:55:54

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

Used parameter files:
sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521))) (LOAD_BALANCE = on)(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = service_name)))

Is there any way to force tnsping to timeout after n seconds? Any idea on why the remaining string is not seen from the program output?

• Shekar

Received on Sat Feb 09 2013 - 05:52:53 CET