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@xxxxxxxxxxxxxxxxx>:
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@xxxxxxxxxxxxxxxxx | https://www.performing-databases.com
------------------------------
*Von: *"Mladen Gogala" <gogala.mladen@xxxxxxxxx>
*An: *oracle-l@xxxxxxxxxxxxx
*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
