Re: TAF and node failover non RAC oracle 10.2

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: andrew.kerber@xxxxxxxxx, hrishys@xxxxxxxxxxx
  • Date: Wed, 30 Jan 2008 06:18:01 -0800 (PST)

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

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








-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'



Other related posts: