Re: rac load balancing
From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Wed, 23 Jan 2008 14:08:07 -0500
Message-ID: <74f79c6b0801231108g72c931dby470ae1f9bdf701fc@mail.gmail.com>
Date: Wed, 23 Jan 2008 14:08:07 -0500
Message-ID: <74f79c6b0801231108g72c931dby470ae1f9bdf701fc@mail.gmail.com>
What does your config look like? listener.ora, tnsnames.ora, remote_listener
and local_listener.
Finn
On 1/22/08, Steiner, Randy <Randy.Steiner_at_nyct.com> wrote:
>
> 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 Wed Jan 23 2008 - 13:08:07 CST