Re: Oracle 10g TAF Vs FAN

Ravip via DBMonster.com 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.
>>
>> http://www.psoug.org/reference/rac.html
>> 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:
http://www.psoug.org/reference/rac.html
Scroll down to the listing:
"TNSNAMES.ORA 10.2.0.1 RedHat Linux AS 4 U2"

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

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org