RE: Trying to wrap my head around TAF

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Thu, 16 Jul 2009 12:14:54 +0200
Message-ID: <4814386347E41145AAE79139EAA398980931A4A090_at_ws03-exch07.iconos.be>



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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fairlie rego Sent: donderdag 16 juli 2009 4:36
To: sacrophyte_at_gmail.com; dannorris_at_dannorris.com 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
Received on Thu Jul 16 2009 - 05:14:54 CDT

Original text of this message