RE: Trying to wrap my head around TAF

I think you could still encounter the following scenario:

* a client is connected to one of the instances
* in this session a query is started and the client is waiting to get the 
results back (no results retrieved yet
* at that moment, the instance fails
* the client keeps waiting


Regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer


________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of fairlie rego
Sent: donderdag 16 juli 2009 4:36
To: sacrophyte@xxxxxxxxx; dannorris@xxxxxxxxxxxxx
Cc: ORACLE-L; Jeremy Schneider
Subject: Re: Trying to wrap my head around TAF

When the primary site really, really fails, the VIPs won't be available and 
that could be a large delay before the client gives up (that's what VIPs were 
intended to prevent).
To get around this problem we use the outbound_connect_timeout in the client's 
sqlnet.ora and have set it to 3 seconds. So incase a vip is offline we do not 
wait forever...

Thanks
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405


--
http://www.freelists.org/webpage/oracle-l


Other related posts: