Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 9ACBB1961239 for ; Fri, 7 Jul 2017 09:07:36 +0200 (CEST) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Fri, 7 Jul 2017 09:07:36 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB45D940F; Fri, 7 Jul 2017 03:07:34 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1499411254; bh=tHg+V0g9cuuMSwrTWEkTQl/+GkxJ7F+g9XLHiqC+n9c=; h=Date:From:To:Cc:In-Reply-To:References:Subject:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=lHTZY0O0fbKcvH9UkDzFZ9fXs78nOtMZskJyvzauClywBaNaK5ab1fjtGBFGKfa/x jkod9AVJzSucioxAjmvp3l6tpx7n05G+t4N8gOjDJOdXkbbXkKRYE7lHP/VZIkjuVc AmnFEImLD1KLd3VmnQE14rIWQgLKDDjOpAq95v08= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tYg_wRY1fX8u; Fri, 7 Jul 2017 03:07:34 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B3DF19444; Fri, 7 Jul 2017 03:07:20 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1499411252; bh=tHg+V0g9cuuMSwrTWEkTQl/+GkxJ7F+g9XLHiqC+n9c=; h=Date:From:To:Cc:In-Reply-To:References:Subject:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=QMPanHw02nu+0k3CG6B3gn0H076WBtFLdpxQttVck8XhhP60yPdNx441w8yFLHRXN nm2BZQ3jEC/fzDKRmezoMMAA30d9WKQEgeSSlAdW6mUG4xuNfNlI1gCODUZb6D38OD 0uTW5qywQESOvLqUz3o+8hwB5zUPHcqYWyLIaNgE= Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2017 03:05:59 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8CAED9408 for ; Fri, 7 Jul 2017 03:05:58 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id POuYZV3sJYTZ for ; Fri, 7 Jul 2017 03:05:58 -0400 (EDT) Received: from mx0.linux-mitterteich.de (mx0.linux-mitterteich.de [88.198.169.86]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id A2E559406 for ; Fri, 7 Jul 2017 03:05:57 -0400 (EDT) Received: from alderaan.pdb.internal (alderaan.pdb.internal [192.168.111.1]) by s-lin-gen-mta-001 (Postfix) with ESMTP id 4E9691FB29; Fri, 7 Jul 2017 09:05:56 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by alderaan.pdb.internal (Postfix) with ESMTP id 4559930427E; Fri, 7 Jul 2017 09:05:56 +0200 (CEST) Received: from alderaan.pdb.internal ([127.0.0.1]) by localhost (alderaan.pdb.internal [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id JPf6gsV9beQh; Fri, 7 Jul 2017 09:05:54 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by alderaan.pdb.internal (Postfix) with ESMTP id B2B34304282; Fri, 7 Jul 2017 09:05:54 +0200 (CEST) Received: from alderaan.pdb.internal ([127.0.0.1]) by localhost (alderaan.pdb.internal [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id P9XSDuYkQiiL; Fri, 7 Jul 2017 09:05:54 +0200 (CEST) Received: from alderaan.pdb.internal (alderaan.pdb.internal [192.168.111.1]) by alderaan.pdb.internal (Postfix) with ESMTP id 6FD7030427E; Fri, 7 Jul 2017 09:05:54 +0200 (CEST) Date: Fri, 7 Jul 2017 09:05:54 +0200 (CEST) From: Martin Klier - Performing Databases GmbH To: Mark Farnham Cc: Ethan Post , Martin Berger , Oracle-L oracle-l Message-ID: <1818529611.671.1499411154340.JavaMail.zimbra@performing-db.com> In-Reply-To: <027801d2f651$bb36cb80$31a46280$@rsiz.com> References: <1102566890.2106.1498735475833.JavaMail.zimbra@performing-db.com> <9318cbf1-cc52-6d99-9bc7-4d9cc3c9fe8f@gmail.com> <1466277677.1482.1498821721635.JavaMail.zimbra@performing-db.com> <1255527857.1020.1499079159515.JavaMail.zimbra@performing-db.com> <00e101d2f407$cb34a8a0$619df9e0$@gmail.com> <2084840861.1566.1499160251285.JavaMail.zimbra@performing-db.com> <027801d2f651$bb36cb80$31a46280$@rsiz.com> Subject: Re: RAC One Node - Instances not open at the same time! MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_670_1829051744.1499411154339" Thread-Topic: RAC One Node - Instances not open at the same time! X-archive-position: 68723 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: martin.klier@performing-db.com Precedence: normal Reply-To: martin.klier@performing-db.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l ------=_Part_670_1829051744.1499411154339 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Mark,=20 thanks for your reply. Will all the service-centered approaches work for db= ms_jobs?=20 Thanks=20 Martin=20 --=20 Martin Klier | Performing Databases GmbH=20 Managing Partner | Senior DB Consultant=20 Oracle ACE=20 martin.klier@performing-db.com | https://www.performing-databases.com=20 > Von: "Mark Farnham" > An: "martin klier" , "Ethan Post" > > CC: "Martin Berger" , "Oracle-L oracle-l" > > Gesendet: Donnerstag, 6. Juli 2017 14:16:42 > Betreff: RE: RAC One Node - Instances not open at the same time! > Did I miss a memo and service connection node preference is not available= on > =E2=80=9COne Node?=E2=80=9D > My initial reaction is that having one or the other node as preferred and= then > restarting the service the opposite if a node is intentionally down would= be a > reasonable solution that, for example, allows non-application work to res= ide in > the instance shared pool and possibly buffer cache of the non-preferred > instance. > Your mileage may vary. > mwf > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org= ] On > Behalf Of Martin Klier - Performing Databases GmbH > Sent: Tuesday, July 04, 2017 5:24 AM > To: Ethan Post > Cc: Martin Berger; Oracle-L oracle-l > Subject: Re: RAC One Node - Instances not open at the same time! > Ethan, > thank you very much. > -- > Martin Klier | Performing Databases GmbH > Managing Partner | Senior DB Consultant > Oracle ACE > martin.klier@performing-db.com | https://www.performing-databases.com >> Von: "Ethan Post" < post.ethan@gmail.com > >> An: "martin klier" < martin.klier@performing-db.com >, "Martin Berger" < >> martin.a.berger@gmail.com > >> CC: "Oracle-L oracle-l" < oracle-l@freelists.org > >> Gesendet: Montag, 3. Juli 2017 16:22:22 >> Betreff: RE: RAC One Node - Instances not open at the same time! >> 2 cents >> My recommendation would be to set up an alert that opens ticket, sends >> email/message etc=E2=80=A6when two instances are running with an explana= tion of the >> reasons both should not be open unless the potential for problems is tru= ly high >> risk issue. >> The =E2=80=9Ctrigger=E2=80=9D solution is good but if you are in a high = turnover environment, >> moving to cloud someday, cloning, replicating system, doing upgrades etc= =E2=80=A6there >> is a chance this will come back to bite someone someday. It isn=E2=80=99= t obvious >> enough, whereas the alert would be very obvious. >> So if you have big data/job corruption issue then it needs to be enforce= d >> strictly, otherwise go with an notify solution. >> Thanks >> From: oracle-l-bounce@freelists.org [ mailto:oracle-l-bounce@freelists.o= rg ] On >> Behalf Of Martin Klier - Performing Databases GmbH >> Sent: Monday, July 3, 2017 5:53 AM >> To: Martin Berger < martin.a.berger@gmail.com > >> Cc: Oracle-L oracle-l < oracle-l@freelists.org > >> Subject: 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@performing-db.com | https://www.performing-databases.com >>> Von: "Martin Berger" < martin.a.berger@gmail.com > >>> An: "Martin Klier" < martin.klier@performing-db.com > >>> CC: "Oracle-L oracle-l" < oracle-l@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@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@performing-db.com | https://www.performing-databases.com >>>>> Von: "Mladen Gogala" < gogala.mladen@gmail.com > >>>>> An: oracle-l@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 wrot= e: >>>>>> Hi Listers, >>>>>> when running Oracle RAC One Node, is there a way to avoid both insta= nces being >>>>>> open at the same time? >>>>>> Background: >>>>>> I have an application that's by no way ready for RAC (using dbms_job= s and much >>>>>> more). But they want to use the benefits of One Node for operating t= he cluster. >>>>>> All that's needed is a failover cluster. >>>>> Please post the output of srvctl config db -d . >>>>> -- >>>>> Mladen Gogala >>>>> Oracle DBA >>>>> Tel: (347) 321-1217 ------=_Part_670_1829051744.1499411154339 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Mark,

=
thanks for your reply. Will all the service-centered approa= ches work for dbms_jobs?

Thanks
Martin


--
Martin Klier | Performing Databases Gm= bH
Managing Partner | Senior DB Consultant
Oracle ACE

martin.k= lier@performing-db.com | https://www.performing-databases.com

=
An: "martin kli= er" <martin.klier@performing-db.com>, "Ethan Post" <post.ethan@gma= il.com>
CC: "Martin Berger" <martin.a.berger@gmail.com>,= "Oracle-L oracle-l" <oracle-l@freelists.org>
Gesendet: Don= nerstag, 6. Juli 2017 14:16:42
Betreff: RE: RAC One Node - Instan= ces not open at the same time!

Did I miss a memo and service connection node preference= is not available on =E2=80=9COne Node?=E2=80=9D

 

My initial reaction is that having one or t= he other node as preferred and then restarting the service the opposite if = a node is intentionally down would be a reasonable solution that, for examp= le, allows non-application work to reside in the instance shared pool and p= ossibly buffer cache of the non-preferred instance.

 

Your mileage may vary.

 

mwf

 

From: oracle-l-bounce@freelists.or= g [mailto:oracle-l-bounce@freelists.org] On Behalf Of Martin Klier -= Performing Databases GmbH
Sent: Tuesday, July 04, 2017 5:24 AMTo: Ethan Post
Cc: Martin Berger; Oracle-L oracle-l
<= b>Subject: Re: RAC One Node - Instances not open at the same time!

 

Ethan,

 

thank you very much.

--
Martin Klier | Performing Data= bases GmbH
Managing Partner | Senior DB Consultant
Oracle ACE

= martin.= klier@performing-db.com | https://www.performing-databases.com

 

Von: "Ethan Post" <post.ethan@gmail.com>
An: "martin klie= r" <= martin.klier@performing-db.com>, "Martin Berger" <martin.a.berger@gmail.com>
CC: "Oracle-L oracle-l" <oracle-l@freelists.org>
Gesendet= : Montag, 3. Juli 2017 16:22:22
Betreff: RE: RAC One Node - I= nstances not open at the same time!

2 cents

 

My recommendation would be to set up an alert that open= s ticket, sends email/message etc=E2=80=A6when two instances are running wi= th an explanation of the reasons both should not be open unless the potenti= al for problems is truly high risk issue.

 

The =E2=80=9Ctrigger=E2=80=9D solution is good but i= f you are in a high turnover environment, moving to cloud someday, cloning,= replicating system, doing upgrades etc=E2=80=A6there is a chance this will= come back to bite someone someday. It isn=E2=80=99t obvious enough, wherea= s the alert would be very obvious.

 

So if you have big data/job corruption issue then it needs= to be enforced strictly, otherwise go with an notify solution.

 

Thanks

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce= @freelists.org] On Behalf Of Martin Klier - Performing Databases= GmbH
Sent: Monday, July 3, 2017 5:53 AM
To: Martin Ber= ger <mart= in.a.berger@gmail.com>
Cc: Oracle-L oracle-l <oracle-l@freelists.org= >
Subject: Re: RAC One Node - Instances not open at the sa= me time!

 

Martin,

 

sounds very cool. Thanks!

 

--
Martin Klier | Performing Databases Gm= bH
Managing Partner | Senior DB Consultant
Oracle ACE

martin.klier@p= erforming-db.com | https://www.performing-databases.com

 

Von: "Martin= Berger" <martin.a.berger@gmail.com>
An: "Martin Klier" <martin.klier@p= erforming-db.com>
CC: "Oracle-L oracle-l" <oracle-l@freelists.org&= gt;
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:&nbs= p;

 <= /p>

you write a sta= rtup trigger which immediately set 

alter system enable restricted session;=

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

<= div>

at the end do =

alter = system disable restricted session;

 

 

(everything is untested right now on my side)

 

Martin

 

2017-06-30 13:22 GMT+02:00 Martin Klier - Perform= ing Databases GmbH <martin.klier@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
Ora= cle ACE

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

 

=

 

&nb= sp;

 


------=_Part_670_1829051744.1499411154339-- -- http://www.freelists.org/webpage/oracle-l