Re: tnsping and sqlplus connect timeout

On Jul 4, 11:07 am, nodge <nodge.trott..._at_googlemail.com> wrote:
> Hey guys,
>
> I've got 4 databases running on 2 servers - each server is connected
> to 2 networks.
>
> 172.27.133.* and 172.27.134.*
>
> So both servers have 2 IP addresse which is in the listener.ora file.
>
> emp=
> (DESCRIPTION =
> (ENABLE = BROKEN )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.133.1) (PORT =
> 1601))
> (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.133.6) (PORT =
> 1602))
> (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.134.1) (PORT =
> 1601))
> (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.134.6) (PORT =
> 1602))
> )
> (CONNECT_DATA = (SERVICE_NAME = emp.world)(failover_mode =
> (type = session)(method = basic)))
> )
>
> If i do a tnsping it try's 20s to connect to 172.27.133.1 and then to
> 172.27.133.6 - 20s. So I'll be connected to 172.27.134.1 at 44s. Thats
> a long time.
>
> My problem is: when the 133 switch is down a tnsping / sqlplus need
> 20seconds for ever connect attempt. How could I set this "connect
> attempt timeout" to a lower value? I suppose it's in sqlnet.ora?
>
> Thx
> Nodge

Wow, that is a long time to connect, regardless. I would talk to your network guys. Until then, look up SQLNET.INBOUND_CONNECT_TIMEOUT in the doco.

HTH, Steve Received on Wed Jul 04 2007 - 14:23:16 CDT