Re: RAC One Node - Instances not open at the same time!

Martin,

sounds very cool. Thanks!

-- 
Martin Klier | Performing Databases GmbH 
Managing Partner | Senior DB Consultant 
Oracle ACE 

martin.klier_at_performing-db.com | https://www.performing-databases.com 



> Von: "Martin Berger" <martin.a.berger_at_gmail.com>

> An: "Martin Klier" <martin.klier_at_performing-db.com>

> CC: "Oracle-L oracle-l" <oracle-l_at_freelists.org>

> Gesendet: Freitag, 30. Juni 2017 14:32:00


> Betreff: Re: RAC One Node - Instances not open at the same time!





> Hi Martin,


> as this is an open discussion what's about this concept:





> you write a startup trigger which immediately set

> alter system enable restricted session;

> then it spools gv$instance until it's sure the other instance is gone,

> at the end do


> alter system disable restricted session;





> that's maybe not a very elegant method, but it might solve your request?





> (everything is untested right now on my side)





> Martin





> 2017-06-30 13:22 GMT+02:00 Martin Klier - Performing Databases GmbH <


> martin.klier_at_performing-db.com > :



>> Why? It's an open concept discussion, no system was configured yet.

>> --
>> Martin Klier | Performing Databases GmbH
>> Managing Partner | Senior DB Consultant
>> Oracle ACE

>> martin.klier_at_performing-db.com | https://www.performing-databases.com

>>> Von: "Mladen Gogala" < gogala.mladen_at_gmail.com >
>>> An: oracle-l_at_freelists.org
>>> Gesendet: Freitag, 30. Juni 2017 00:21:30
>>> Betreff: Re: RAC One Node - Instances not open at the same time!

>>> On 06/29/2017 07:24 AM, Martin Klier - Performing Databases GmbH wrote:

>>>> Hi Listers,

>>>> when running Oracle RAC One Node, is there a way to avoid both instances being
>>>> open at the same time?

>>>> Background:
>>>> I have an application that's by no way ready for RAC (using dbms_jobs and much
>>>> more). But they want to use the benefits of One Node for operating the cluster.
>>>> All that's needed is a failover cluster.

>>> Please post the output of srvctl config db -d <DB name>.
>>> --
>>> Mladen Gogala
>>> Oracle DBA
>>> Tel: (347) 321-1217

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