Re: rac: service failover when multiple instances are listed as "available"

From: LS Cheng <exriscer_at_gmail.com>
Date: Mon, 16 Aug 2010 16:31:04 +0200
Message-ID: <AANLkTik6h=-bm-u99DMP7vVcb+LmPX9JN8rjeD7fjgne_at_mail.gmail.com>



It's random, if you want to control which is more preferreable you have to use callout scripts

Thanks

--
LSC


On Mon, Aug 16, 2010 at 1:32 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:


> Hi,
>
> Does someone know how Oracle will decide to which instance a service will
> failover if multiple instances are marked as available for that service?
>
> Is it to the least loaded node?
> Is it the same node to which the vip of the failed node will failover?
>
> The environment consists out of a 3 node rac and Oracle version is 10.2.0.4
> on windows 2003 (not my decision).
>
> Unfortionatly I don't have permission to fail some nodes to test it myself
> ... :-(
>
>
> Regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 16 2010 - 09:31:04 CDT

Original text of this message