Re: tnsping utility and timeout

On Friday, February 8, 2013 9:52:53 PM UTC-7, cti..._at_gmail.com wrote:
> Hello,
>
>
>
> 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

It appears to me the entire connection string is returned. What do you think is missing? Even on a RAC database the tnsnames.ora entry is returned in its entirety by tnsping.

And I know of no way to initiate a timeout for tnsping.

David Fitzjarrell Received on Fri Feb 22 2013 - 22:30:15 CET