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. Bill Wagman Univ. of California at Davis IET Campus Data Center wjwagman@xxxxxxxxxxx (530) 754-6208 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dan Norris Sent: Wednesday, January 30, 2008 6:18 AM To: andrew.kerber@xxxxxxxxx; hrishys@xxxxxxxxxxx Cc: LS Cheng; oracle-l@xxxxxxxxxxxxx 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. Dan ----- Original Message ---- From: Andrew Kerber <andrew.kerber@xxxxxxxxx> To: hrishys@xxxxxxxxxxx Cc: LS Cheng <exriscer@xxxxxxxxx>; oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxx> wrote: Hi 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.'