Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Taf issue in 9i rac on redhat linux 3

RE: Taf issue in 9i rac on redhat linux 3

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Fri, 3 Jun 2005 09:49:47 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BBF6@ecogenemld50.Org.Collegeboard.local>


Arun,
I when I used TAF the failover-reconnect was immediate. I do not believe I used LOAD_BALANCE nor FAILOVER (v8, v9) during my tests. And I have no idea what the "enable = broken" parameter does.

But I agree with Christian, try TAF config without these. I to think I had session confusion when using these various connection parameters and TAF. The all do different things regarding "when", "how", and "what" to connect to...I will look through my old notes?

Good luck and keep us posted on what you find.

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Christian Antognini Sent: Fri 6/3/2005 3:07 AM
To: arunrao_oradba_at_yahoo.co.in
Cc: oracle-l_at_freelists.org
Subject: RE: Taf issue in 9i rac on redhat linux 3  

Arun  

>If one of the nodes freezes(like powering down the

>node)the TAF clients are taking a very long time to

>failover to the working node almost i can say around

>10 to 15 mins
 

I don't know if it's relevant for your problem, anyway, with LOAD_BALANCE=ON I was able to reproduce at will the following problem by one of my customers a couple of years ago (was 9.2.0.4, I think...).  

Let's say we have two nodes. Node A is much more loaded than node B (I know, it should not happen since LOAD_BALANCE=ON, but we work with real systems...). Now, when node B crashes (e.g. powered off...), the new connections should go to node A. But, the listener on node A is still thinking that node B is there AND is less loaded. Therefore they are forwarded to node B... Since node B is not up and running the client gets a nice error!  

We find only two methods to solve this problem:

Therefore, IMO, you should do some tests without LOAD_BALANCE=ON.    

HTH Chris

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



--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 03 2005 - 09:54:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US