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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Dual Head on ATI Mobility X1300 (Original Posting without X-No-Archive)
    ... dual head configuration for an ATI Mobility Radeon X1300 in an IBM T60 ... (of course adapted to the respective monitor resolution), ... Load "bitmap" ... Driver "mouse" ...
    (comp.os.linux.x)
  • Xorg xserver blank using one kernel, but ok using another
    ... because xorg.conf is the same whether it's runinng under Xen or a normal kernel. ... The main difference beteween the blank screen and the ok screen is that when the display works, I get "VESA VBE DDC supported" but when it goes blank I get "VESA VBE DDC not supported". ... # This file was generated by dexconf, the Debian X Configuration tool, using ... Load "bitmap" ...
    (Debian-User)
  • Re: Xorg xserver blank using one kernel, but ok using another
    ... because xorg.conf is the same whether it's runinng under Xen or a normal kernel. ... The main difference beteween the blank screen and the ok screen is that when the display works, I get "VESA VBE DDC supported" but when it goes blank I get "VESA VBE DDC not supported". ... # This file was generated by dexconf, the Debian X Configuration tool, using ... Load "bitmap" ...
    (Debian-User)
  • Re: Suggested Module Namespace ( themes, design Tk widget)?
    ... If user just load Tk::Dressing, nothing will be happened with the ... The only way to change the design of your widget is to ... I think using an xml to set configuration is not good. ... That is why I have decided to upload this module to CPAN. ...
    (comp.lang.perl.modules)
  • Re: [9.2.2] Startup freeze related to UMAX scanner sw? NO! SOLVED!
    ... been able to boot into my image editing configuration successfully till ... During the loading of extensions, most items load, the last icon ... This scanner is normally inactive, ... Extensions Manager, then add in one extension at a time to see what is ...
    (comp.sys.mac.system)