tnsping and sqlplus connect timeout

From: nodge <nodge.trottier_at_googlemail.com>
Date: Wed, 04 Jul 2007 08:07:42 -0700
Message-ID: <1183561662.382151.44640@c77g2000hse.googlegroups.com>

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 Received on Wed Jul 04 2007 - 10:07:42 CDT