Re: RAC: Testing unplanned outage (1 instance goes down)

From: Alfredo Abate <alfredo.abate_at_gmail.com>
Date: Mon, 9 May 2016 10:45:40 -0500
Message-ID: <CALrB5po4pYxo3E8buB08D5HS=A6DS89X8VHeZcAhc1o91CGizA_at_mail.gmail.com>

Is there anything in the MOS provided document, RAC System Test Plan Outline, that would help you with this?

Alfredo

On Mon, May 9, 2016 at 9:57 AM, Igor Racic <igor.racic_at_gmail.com> wrote:

> Hi Stefan,
>
> Thank you for heads up.
>
> Regards,
> Igor
>
>
> 2016-05-09 16:45 GMT+02:00 Stefan Koehler <contact_at_soocs.de>:
> > Hello Igor,
> > please be aware of "dispersion", if you are going to play with network
> down/up in RAC. Markus Michalewicz explained it very nicely in a Tweet by
> > Martin Berger: https://twitter.com/martinberx/status/681445522050256896
> >
> > Best Regards
> > Stefan Koehler
> >
> > Freelance Oracle performance consultant and researcher
> > Homepage: http://www.soocs.de
> > Twitter: _at_OracleSK
> >
> >> Igor Racic <igor.racic_at_gmail.com> hat am 9. Mai 2016 um 16:30
> geschrieben:
> >>
> >>
> >> Hi,
> >>
> >> When you do instance shutdown in sqlplus using shutdown (even abort)
> >> or alter pluggable database ... close, srvctl stop database or
> >> instance,
> >> Oracle gets that it's you stopping it and it treats it as planned
> outage.
> >> Killing pmon (without -9) works (likely as OS shutdown/restart).
> >> On the other hand, for application FCF tests, I am wondering what
> >> would be the lighest/fastest way to convince Oracle that unplanned
> >> outage just happened (and switch back to retry the test again).
> >>
> >> I have crossed somewhere that playing with OS network interfaces can
> >> do it, didn't test it yet.
> >> Any other candidate ?
> >>
> >> Thank you and regards,
> >> Igor
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 09 2016 - 17:45:40 CEST