Re: registering non-RAC databases and listeners in Clusterware

Hello.

by default: *srvctl add database* will add *RAC* db

so need to use *-dbtype SINGLE*:

    srvctl add database -d ${ORACLE_SID?} -o ${ORACLE_HOME?} *-dbtype SINGLE* -node ${DB_NODE?}     -spfile ${SPFILE?} -pwfile ${PWFILE?} -diskgroup ${ASM_DISKGROUPS?}

    use srvctl add database -h

        for all possible options

after adding listener using: *srvctl add listener*

specify instance parameter LOCAL_LISTENER pointing new listener.

if you need to be able to connect through SCAN listeners, specify SCAN listener as a instance parameter REMOTE_LISTENER

Best Regards,

     Oleksandr Denysenko

02.02.2021 21:45, Mladen Gogala ïèøåò:
>
> 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

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