Subject: Re: registering non-RAC databases and listeners in Clusterware
To: oracle-l@freelists.org
References: <f8b08feebbb0438cb9911201b79b9824@vontobel.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <4588a6ac-1256-aede-1254-a9d83bc3a476@gmail.com>
Date: Tue, 2 Feb 2021 14:45:25 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.0
MIME-Version: 1.0
In-Reply-To: <f8b08feebbb0438cb9911201b79b9824@vontobel.com>
Content-Type: multipart/alternative;
 boundary="------------16F4B07FEC4094E83A79B63E"
Content-Language: en-US
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com
--------------16F4B07FEC4094E83A79B63E
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

srvctl add database -d <db name>

srvctl add instance -i $ORACLE_SID -d <db_name> -n <node name>

srvctl add listener l<listener name> -oraclehome $ORACLE_HOME =user 
oracle -endpoints TCP:<port>

On 2/2/21 12:58 PM, Noveljic Nenad wrote:
>
> What’s the correct way to register a single-node (non-RAC) 19c 
> database and its local listener in Clusterware? We don’t need SCAN 
> listeners.
>
> There is a documentation for configuring single-node database with 
> Oracle Restart, and RAC databases with Clusterware, but apparently 
> nothing about integrating non-RAC databases in Clusterware.
>
> We haven’t installed Clusterware just for fun – we had to because we 
> keep our data files on ACFS. Now, we’re thinking of using it to start 
> crashed databases and listeners, but only if that isn’t too much 
> trouble. Otherwise, we have another solution ready.
>
> Thanks,
>
> Nenad
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
>
> This message is intended only for the individual named. It may contain 
> confidential or privileged information. If you are not the named 
> addressee you should in particular not disseminate, distribute, modify 
> or copy this e-mail. Please notify the sender immediately by e-mail, 
> if you have received this message by mistake and delete it from your 
> system.
> Without prejudice to any contractual agreements between you and us 
> which shall prevail in any case, we take it as your authorization to 
> correspond with you by e-mail if you send us messages by e-mail. 
> However, we reserve the right not to execute orders and instructions 
> transmitted by e-mail at any time and without further explanation.
> E-mail transmission may not be secure or error-free as information 
> could be intercepted, corrupted, lost, destroyed, arrive late or 
> incomplete. Also processing of incoming e-mails cannot be guaranteed. 
> All liability of Vontobel Holding Ltd. and any of its affiliates 
> (hereinafter collectively referred to as "Vontobel Group") for any 
> damages resulting from e-mail use is excluded. You are advised that 
> urgent and time sensitive messages should not be sent by e-mail and if 
> verification is required please request a printed version.
> Please note that all e-mail communications to and from the Vontobel 
> Group are subject to electronic storage and review by Vontobel Group. 
> Unless stated to the contrary and without prejudice to any contractual 
> agreements between you and Vontobel Group which shall prevail in any 
> case, e-mail-communication is for informational purposes only and is 
> not intended as an offer or solicitation for the purchase or sale of 
> any financial instrument or as an official confirmation of any 
> transaction.
> The legal basis for the processing of your personal data is the 
> legitimate interest to develop a commercial relationship with you, as 
> well as your consent to forward you commercial communications. You can 
> exercise, at any time and under the terms established under current 
> regulation, your rights. If you prefer not to receive any further 
> communications, please contact your client relationship manager if you 
> are a client of Vontobel Group or notify the sender. Please note for 
> an exact reference to the affected group entity the corporate e-mail 
> signature. For further information about data privacy at Vontobel 
> Group please consult www.vontobel.com <https://www.vontobel.com>.
>
-- 
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com


--------------16F4B07FEC4094E83A79B63E
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body>
    <p>srvctl add database -d &lt;db name&gt;</p>
    <p>srvctl add instance -i $ORACLE_SID -d &lt;db_name&gt; -n &lt;node
      name&gt;</p>
    <p>srvctl add listener l&lt;listener name&gt; -oraclehome
      $ORACLE_HOME =user oracle -endpoints TCP:&lt;port&gt;<br>
    </p>
    <div class="moz-cite-prefix">On 2/2/21 12:58 PM, Noveljic Nenad
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:f8b08feebbb0438cb9911201b79b9824@vontobel.com">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style>@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Arial",sans-serif;
	color:windowtext;}.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}div.WordSection1
	{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US">What’s the correct way to register a
            single-node (non-RAC) 19c database and its local listener in
            Clusterware? We don’t need SCAN listeners.<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US">There is a documentation for configuring
            single-node database with Oracle Restart, and RAC databases
            with Clusterware, but apparently nothing about integrating
            non-RAC databases in Clusterware. <o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US">We haven’t installed Clusterware just for fun –
            we had to because we keep our data files on ACFS. Now, we’re
            thinking of using it to start crashed databases and
            listeners, but only if that isn’t too much trouble.
            Otherwise, we have another solution ready.<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US">Thanks,<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US">Nenad<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"
            lang="EN-US"><o:p> </o:p></span></p>
      </div>
      <style type="text/css">p.MsoNormal
	{margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	margin-left: 0cm;
	margin-right: 0cm;
	margin-top: 0cm;
}</style>
      <p class="MsoNormal"><span
          style="color:green;mso-ansi-language:EN-US;
          mso-fareast-language:DE-CH" lang="EN-US">____________________________________________________<o:p></o:p></span></p>
      <p class="MsoNormal"><span
          style="color:green;mso-ansi-language:EN-US;
          mso-fareast-language:DE-CH" lang="EN-US">Please consider the
          environment before printing this e-mail.<o:p></o:p></span></p>
      <p class="MsoNormal"><span
          style="color:green;mso-fareast-language:DE-CH">Bitte denken
          Sie an die Umwelt, bevor Sie dieses E-Mail drucken.</span><span
          style="color:green"><o:p></o:p></span></p>
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <style type="text/css">p { font-family: Arial;font-size:9pt }</style>
      <p>
        <br>
        Important Notice<br>
        <br>
        This message is intended only for the individual named. It may
        contain confidential or privileged information. If you are not
        the named addressee you should in particular not disseminate,
        distribute, modify or copy this e-mail. Please notify the sender
        immediately by e-mail, if you have received this message by
        mistake and delete it from your system.<br>
        Without prejudice to any contractual agreements between you and
        us which shall prevail in any case, we take it as your
        authorization to correspond with you by e-mail if you send us
        messages by e-mail. However, we reserve the right not to execute
        orders and instructions transmitted by e-mail at any time and
        without further explanation.<br>
        E-mail transmission may not be secure or error-free as
        information could be intercepted, corrupted, lost, destroyed,
        arrive late or incomplete. Also processing of incoming e-mails
        cannot be guaranteed. All liability of Vontobel Holding Ltd. and
        any of its affiliates (hereinafter collectively referred to as
        "Vontobel Group") for any damages resulting from e-mail use is
        excluded. You are advised that urgent and time sensitive
        messages should not be sent by e-mail and if verification is
        required please request a printed version.<br>
        Please note that all e-mail communications to and from the
        Vontobel Group are subject to electronic storage and review by
        Vontobel Group. Unless stated to the contrary and without
        prejudice to any contractual agreements between you and Vontobel
        Group which shall prevail in any case, e-mail-communication is
        for informational purposes only and is not intended as an offer
        or solicitation for the purchase or sale of any financial
        instrument or as an official confirmation of any transaction.<br>
        The legal basis for the processing of your personal data is the
        legitimate interest to develop a commercial relationship with
        you, as well as your consent to forward you commercial
        communications. You can exercise, at any time and under the
        terms established under current regulation, your rights. If you
        prefer not to receive any further communications, please contact
        your client relationship manager if you are a client of Vontobel
        Group or notify the sender.
        Please note for an exact reference to the affected group entity
        the corporate e-mail signature.
        For further information about data privacy at Vontobel Group
        please consult <a href="https://www.vontobel.com"
          moz-do-not-send="true">www.vontobel.com</a>.<br>
      </p>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a></pre>
  </body>
</html>

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