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>
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?
Thanks
Randy
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 22 2008 - 10:44:38 CST