RE: TAF and node failover non RAC oracle 10.2
Date: Wed, 30 Jan 2008 11:52:54 -0800
Indeed it will. I just attended Oracle's RAC deployment training last week and this is one of the exercises we went through in training. It does work.
Univ. of California at Davis
IET Campus Data Center
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dan Norris Sent: Wednesday, January 30, 2008 6:18 AM To: andrew.kerber_at_gmail.com; hrishys_at_yahoo.co.uk Cc: LS Cheng; oracle-l_at_freelists.org
Subject: Re: TAF and node failover non RAC oracle 10.2
Maybe I missed something earlier in this part of the thread, but using Oracle Clusterware to build a single-instance failover cluster absolutely will work. I'm not sure that TAF is going to be of any help, but you could use TAF if you wish. The RETRIES and DELAY parameters may help to reconnect, but your application will still need to handle the state of the session once it is reestablished (may need to rollback).
Most connection pools have retry logic built in to them, so TAF isn't probably helpful/necessary in scenarios like this.
- Original Message ---- From: Andrew Kerber <andrew.kerber_at_gmail.com> To: hrishys_at_yahoo.co.uk Cc: LS Cheng <exriscer_at_gmail.com>; oracle-l_at_freelists.org Sent: Wednesday, January 30, 2008 7:42:01 AM Subject: Re: TAF and node failover non RAC oracle 10.2
No, taf wont work that way. Your 3rd party provider would have to deal with it.
On Jan 30, 2008 6:55 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:
Hmm how about using Oracle clusterware and build a active passive instance would that work ? regards Hrishy __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 30 2008 - 13:52:54 CST