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