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:
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
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-lReceived on Thu Jul 16 2009 - 05:14:54 CDT