RE: TAF and node failover non RAC oracle 10.2

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_at_ucdavis.edu
(530) 754-6208  

From: oracle-l-bounce_at_freelists.org
[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.

Dan

• 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:

        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.' 


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