Database Software

Hi,

I have RAC , but using FALOVER option to route connection.

Got the FAILOVER=ON , LOADBALANCE = OFF in the tnsnames.ora file,
tested with primary's listener down,db down ...takes about extra 1sec to connect, which is fine. but when Node is unreacheable the switch takes 20secs extra.

I am looking to see how.

tried with sqlnet.ora

SQLNET.INBOUND_CONNECT_TIMEOUT = 1
SQLNET.RECV_TIMEOUT = 1


tried with tnsname.ora

test_failover =
(description =
(failover = True )
(load_balance = False )
(address_list =
(address = (protocol = Tcp)(host = x.x.x.x)(port = 1521))
(address = (protocol = Tcp)(host = x.x.x.x)(port = 1521))
)
(connect_data =
(SERVICE_NAME= labo)
)
)


it does a smooth failover in two cases ( case1 when listener is down , case2 when db is down ), it also works in third case with a timedelay of 20seconds ,ie when the primary node is down.

I am trying to cut down the default timeout ( os side or oracle side ) so that the failover should happen immediatly without adding the timeout cushion time.


Is there some parameter i have to add in my registery

I'm under window 2003 sp2 for server and window xp sp3 for the client where i do my test.

Thanks

Thanks