rac load balancing

From: Steiner, Randy <Randy.Steiner_at_nyct.com>
Date: Tue, 22 Jan 2008 11:44:38 -0500
Message-ID: <D5006AF7251D5046A0A63E39A23148DC01216AB7@NYCTEXVS07.transit.nyct.com>

I have a rac with 4 nodes.

When all for instances are up, the load balancing works fine. As proof, I do this in sqlplus

    Connect user/pw_at_service

    Select * from v$instance.

And I see a reasonable randomness for all 4 nodes.  

But when I shutdown the instance on node 1 or 2 and did the same thing I did not see a connection to node 4.

I have not tried node 3 yet.  

Does anyone have an idea what might be going on?  



Received on Tue Jan 22 2008 - 10:44:38 CST

Original text of this message