Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g TAF Vs FAN

Re: Oracle 10g TAF Vs FAN

From: DA Morgan <>
Date: Tue, 18 Sep 2007 08:20:09 -0700
Message-ID: <>

Ravip via wrote:
> My scenario is, I have a application server in between the front end and
> database. During the service configuration the TNSNAMES.ORA is rightly
> mentioned with the parameters that is mentioned in URL that you mentioned.
> I have 2 node cluster and as of now only 1 of the node is having the full
> load. I'm using Webspere as the middle tier. There are some occassions where
> only 1 node in the RAC was fully loaded and the CPU reached 100% and
> continued for 3-4 minutes, then it came down. Obvious reason for the load is
> bad queries and some of them has been rectified.
> But my doubt is, if the load balance is enabled or working fine, during the
> 100% CPU usage of Node 1, the load has to be distribute to the 2nd node -
> right ? But it doesn't happen and at that time the 2 node load was just 2%.
> To make this work load evenly distributed between 2 nodes, what configuration
> should I check and change ?
> Thank You.
> DA Morgan wrote:

>>>>> Hi,
>> [quoted text clipped - 15 lines]
>>> I have configured the services based on TAF policy. The first node is
>>> preferable and the second node is available. 
>> You really need to read the documentation. TAF has absolutely nothing to
>> do with listener load balancing.
>> If you configure your TNSNAMES.ORA properly the nodes will load balance
>> themselves.
>> Look at the TNSNAMES.ORA

People read from top to bottom. Please do not top post or you will be ignored by most. Scroll to the bottom to reply.

You wrote:
" I have 2 node cluster and as of now only 1 of the node is having the full load."

Which is a clear indication that while you may or may not have a RAC cluster you definitely do not have it configured properly. Post your tnsnames.ora file. Also validate that your login is to the service and not to an instance.

Take a look at this page again:
Scroll down to the listing:
"TNSNAMES.ORA RedHat Linux AS 4 U2"

Note that the same cluster can addressed as: TSTA.TAF ... the TAF service
Each one produces a different behavior.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Sep 18 2007 - 10:20:09 CDT

Original text of this message