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

From: Igor Racic <igor.racic_at_gmail.com>
Date: Mon, 9 May 2016 16:57:50 +0200
Message-ID: <CAGjkCBY98b2AcAJ-_imc3X5Uip7wOc60HzeorRrLHuFA+1BEOQ_at_mail.gmail.com>



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
Received on Mon May 09 2016 - 16:57:50 CEST

Original text of this message