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

From: Stefan Koehler <contact_at_soocs.de>
Date: Mon, 9 May 2016 16:45:16 +0200 (CEST)
Message-ID: <1426436579.1145055.1462805116919.JavaMail.open-xchange_at_app09.ox.hosteurope.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

Received on Mon May 09 2016 - 16:45:16 CEST