Re: Oracle 10g TAF Vs FAN

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

-- 
Message posted via http://www.dbmonster.com