سلام 

یکی از دوستان درخواست تغییر clustername رو داشتن که من این مقاله رو برای این گذاشتم که دیگر دوستان هم استفاده کنن

خب برای اینکار ما باید ابتدا کلاستر رو deconfig کنیم و دوباره config کنیم 

اینکه این کار باعث downtime میشه و اینکه دیتابس ما حذف نمیشه بعد از config ما این دیتابیس رو به cluster اضافه میکنیم

خب برای اینکار ابتدا ما با کاربر root کلاستر رو deconfig میکنیم

روی تمام نود ها بجز نود اخر این دستور رو میزنیم

[root@prod1 install]# cd /grid/app/12.2/grid/crs/install
[root@prod1 install]# ./rootcrs.pl -deconfig -force -verbose
Using configuration parameter file: ./crsconfig_params
The log of current session can be found at:
  /grid/grid_base/crsdata/prod1/crsconfig/crsdeconfig_prod1_2019-05-14_04-51-07PM.log
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod1'
CRS-2673: Attempting to stop 'ora.crsd' on 'prod1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'prod1'
CRS-2673: Attempting to stop 'ora.mciprod.db' on 'prod1'
CRS-2673: Attempting to stop 'ora.chad' on 'prod1'
CRS-2677: Stop of 'ora.mciprod.db' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'prod1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'prod1'
CRS-2673: Attempting to stop 'ora.OCRVOTING.dg' on 'prod1'
CRS-2677: Stop of 'ora.FRA.dg' on 'prod1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'prod1' succeeded
CRS-2677: Stop of 'ora.OCRVOTING.dg' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod1'
CRS-2677: Stop of 'ora.asm' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod1'
CRS-2673: Attempting to stop 'ora.ASMNET2LSNR_ASM.lsnr' on 'prod1'
CRS-2677: Stop of 'ora.ASMNET2LSNR_ASM.lsnr' on 'prod1' succeeded
CRS-2677: Stop of 'ora.chad' on 'prod1' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'prod1' has completed
CRS-2677: Stop of 'ora.crsd' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod1'
CRS-2673: Attempting to stop 'ora.crf' on 'prod1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prod1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prod1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod1' succeeded
CRS-2677: Stop of 'ora.crf' on 'prod1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'prod1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'prod1' succeeded
CRS-2677: Stop of 'ora.asm' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prod1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'prod1'
CRS-2673: Attempting to stop 'ora.evmd' on 'prod1'
CRS-2677: Stop of 'ora.ctssd' on 'prod1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prod1'
CRS-2677: Stop of 'ora.cssd' on 'prod1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prod1'
CRS-2677: Stop of 'ora.gipcd' on 'prod1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2019/05/14 16:53:06 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2019/05/14 16:54:10 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2019/05/14 16:54:10 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
کلاستر من دو نود هست.و اگه کلاستر شما بیشتر از 2 نود باشه باز دستور بالا رو بزنید به غیر از نود اخر.
حالا به علت اینکه نود دوم من نود اخرمه این دستور رو میزنم
[root@prod2 install]# ./rootcrs.pl -deconfig -force -verbose -lastnode
Using configuration parameter file: ./crsconfig_params
The log of current session can be found at:
  /grid/grid_base/crsdata/prod2/crsconfig/crsdeconfig_prod2_2019-05-14_04-59-24PM.log
2019/05/14 16:59:26 CLSRSC-332: CRS resources for listeners are still configured
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod2'
CRS-2673: Attempting to stop 'ora.crsd' on 'prod2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'prod2'
CRS-2673: Attempting to stop 'ora.mciprod.db' on 'prod2'
CRS-2677: Stop of 'ora.mciprod.db' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.OCRVOTING.dg' on 'prod2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'prod2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'prod2'
CRS-2677: Stop of 'ora.FRA.dg' on 'prod2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'prod2' succeeded
CRS-2677: Stop of 'ora.OCRVOTING.dg' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod2'
CRS-2677: Stop of 'ora.asm' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod2'
CRS-2673: Attempting to stop 'ora.ASMNET2LSNR_ASM.lsnr' on 'prod2'
CRS-2677: Stop of 'ora.ASMNET2LSNR_ASM.lsnr' on 'prod2' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'prod2' has completed
CRS-2677: Stop of 'ora.crsd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'prod2'
CRS-2673: Attempting to stop 'ora.crf' on 'prod2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prod2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prod2'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod2' succeeded
CRS-2677: Stop of 'ora.crf' on 'prod2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.storage' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod2'
CRS-2677: Stop of 'ora.mdnsd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.asm' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prod2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'prod2'
CRS-2673: Attempting to stop 'ora.evmd' on 'prod2'
CRS-2677: Stop of 'ora.ctssd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prod2'
CRS-2677: Stop of 'ora.cssd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prod2'
CRS-2677: Stop of 'ora.gipcd' on 'prod2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'prod2'
CRS-2672: Attempting to start 'ora.mdnsd' on 'prod2'
CRS-2676: Start of 'ora.mdnsd' on 'prod2' succeeded
CRS-2676: Start of 'ora.evmd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'prod2'
CRS-2676: Start of 'ora.gpnpd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prod2'
CRS-2672: Attempting to start 'ora.gipcd' on 'prod2'
CRS-2676: Start of 'ora.cssdmonitor' on 'prod2' succeeded
CRS-2676: Start of 'ora.gipcd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'prod2'
CRS-2672: Attempting to start 'ora.diskmon' on 'prod2'
CRS-2676: Start of 'ora.diskmon' on 'prod2' succeeded
CRS-2676: Start of 'ora.cssd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'prod2'
CRS-2672: Attempting to start 'ora.ctssd' on 'prod2'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'prod2'
CRS-2676: Start of 'ora.crf' on 'prod2' succeeded
CRS-2676: Start of 'ora.ctssd' on 'prod2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'prod2'
CRS-2676: Start of 'ora.asm' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'prod2'
CRS-2676: Start of 'ora.storage' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'prod2'
CRS-2676: Start of 'ora.crsd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'prod2'
CRS-2677: Stop of 'ora.crsd' on 'prod2' succeeded
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod2'
CRS-2673: Attempting to stop 'ora.storage' on 'prod2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prod2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'prod2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prod2'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod2' succeeded
CRS-2677: Stop of 'ora.storage' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod2'
CRS-2677: Stop of 'ora.mdnsd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.asm' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prod2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'prod2'
CRS-2677: Stop of 'ora.evmd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prod2'
CRS-2677: Stop of 'ora.cssd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'prod2'
CRS-2677: Stop of 'ora.crf' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prod2'
CRS-2677: Stop of 'ora.gipcd' on 'prod2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'prod2'
CRS-2672: Attempting to start 'ora.mdnsd' on 'prod2'
CRS-2676: Start of 'ora.mdnsd' on 'prod2' succeeded
CRS-2676: Start of 'ora.evmd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'prod2'
CRS-2676: Start of 'ora.gpnpd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prod2'
CRS-2672: Attempting to start 'ora.gipcd' on 'prod2'
CRS-2676: Start of 'ora.cssdmonitor' on 'prod2' succeeded
CRS-2676: Start of 'ora.gipcd' on 'prod2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'prod2'
CRS-2672: Attempting to start 'ora.diskmon' on 'prod2'
CRS-2676: Start of 'ora.diskmon' on 'prod2' succeeded
CRS-2676: Start of 'ora.cssd' on 'prod2' succeeded
ASM de-configuration trace file location: /grid/grid_base/cfgtoollogs/asmca/asmcadc_clean2019-05-14_05-02-54-PM.log
ASM Clean Configuration START
ASM Clean Configuration END

ASM instance deleted successfully. Check /grid/grid_base/cfgtoollogs/asmca/asmcadc_clean2019-05-14_05-02-54-PM.log for details.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod2'
CRS-2673: Attempting to stop 'ora.evmd' on 'prod2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prod2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prod2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod2'
CRS-2677: Stop of 'ora.evmd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prod2'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'prod2' succeeded
CRS-2677: Stop of 'ora.cssd' on 'prod2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prod2'
CRS-2677: Stop of 'ora.gipcd' on 'prod2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2019/05/14 17:04:49 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2019/05/14 17:05:39 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2019/05/14 17:05:42 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
2019/05/14 17:05:42 CLSRSC-559: Ensure that the GPnP profile data under the 'gpnp' directory in /grid/app/12.2/grid is deleted on each node before using the software in the current Grid Infrastructure home for reconfiguration
خب حالا کلا کلاستر ما حذف شد البته بدونید که دdتابیس حذف نشده و فقط کلاستر پاک شده

به مسیر زیر میریم تا دوباره کلاستر رو config کنیم
[grid@prod1 ~]$ $ORACLE_HOME/crs/config
[grid@prod1 config]$ ./config.sh
قبل از شروع به config دوباره cluster ما باید ابتدا header  دیسک گروه های OCR رو پاک بکنیم و سپس شروع به نصب کنیم 
برای اینکار مانند زیر عمل میکنیم
ابتدا بدونیم که OCR  ما روی چه diskgroup و دیسکی هست 
در اینجا OCR کلاستر من روی دیسک جداگانه به غیر از DATA بود
root@prod1 install]# su - grid
Last login: Tue May 14 16:51:07 +0430 2019 on pts/0
[grid@prod1 ~]$ ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 grid asmadmin 8, 33 May 14 16:51 DATA01
brw-rw---- 1 grid asmadmin 8, 49 May 14 16:51 FRA01
brw-rw---- 1 grid asmadmin 8, 17 May 14 16:51 OCRVOTE
[grid@prod1 ~]$ dd if=/dev/zero of=/dev/oracleasm/disks/OCRVOTE bs=4096 count=1
1000+0 records in
1000+0 records out

حالا کلاستر رو با نام NEWcluster شروع به کانفیگ میکنیم







خب همین طور که در تصویر اخر میبینیم باید root.sh رو در هر نود اجرا کنیم
[root@prod1 config]# /grid/app/12.2/grid/root.sh
و در اخر روی نود دوم
[root@prod2 ~]# /grid/app/12.2/grid/root.sh
حالا روی نود یک میریم و کلاستر خودمون رو چک میکنیم
[root@prod1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.ASMNET2LSNR_ASM.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.OCRVOTE.dg
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.net1.network
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.ons
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      prod1                    STABLE
               OFFLINE OFFLINE      prod2                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       prod2                    STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       prod1                    STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       prod1                    STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       prod1                    Started,STABLE
      2        ONLINE  ONLINE       prod2                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       prod1                    STABLE
ora.prod1.vip
      1        ONLINE  ONLINE       prod1                    STABLE
ora.prod2.vip
      1        ONLINE  ONLINE       prod2                    STABLE
ora.qosmserver
      1        ONLINE  ONLINE       prod1                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       prod2                    STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       prod1                    STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       prod1                    STABLE
----------------------------------------------------------------------


همین طور که در بالا مشاهده میکنید resource های دیسک و دیتابیس وجود ندارن که ما در ادامه اینا رو اضافه میکنیم
[grid@prod1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 14 18:12:11 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter diskgroup DATA mount;

Diskgroup altered.

SQL> show parameter diskgroup

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      DATA
SQL> alter diskgroup FRA mount
  2  ;

Diskgroup altered.
و برای نود دوم هم میتونیم از دستور زیر استفاده کنیم

[grid@prod1 ~]$ srvctl start diskgroup -diskgroup DATA -node prod2
[grid@prod1 ~]$ srvctl start diskgroup -diskgroup FRA -node prod2
حالا دوباره چک کنیم cluster خودمون رو
[root@prod2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.ASMNET2LSNR_ASM.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.OCRVOTE.dg
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.net1.network
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.ons
               ONLINE  ONLINE       prod1                    STABLE
               ONLINE  ONLINE       prod2                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      prod1                    STABLE
               OFFLINE OFFLINE      prod2                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       prod2                    STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       prod1                    STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       prod1                    STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       prod1                    Started,STABLE
      2        ONLINE  ONLINE       prod2                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       prod1                    STABLE
ora.prod1.vip
      1        ONLINE  ONLINE       prod1                    STABLE
ora.prod2.vip
      1        ONLINE  ONLINE       prod2                    STABLE
ora.qosmserver
      1        ONLINE  ONLINE       prod1                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       prod2                    STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       prod1                    STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       prod1                    STABLE
--------------------------------------------------------------------------------
ما اگه حالا بخواهیم cluster name  رو ببینیم با کاربر grid لاگین میکنیم و دستور زیر رو میزنیم
[root@prod1 install]# su - grid
Last login: Tue May 14 18:12:06 +0430 2019 on pts/1
[grid@prod1 ~]$ olsnodes -c
newcluster12
همیطور که میبینید نام کلاستر ما عوض شده .

خب حالا resource database رو add میکنیم
من ابتدا spfile رو توی asm پیدا کردن و به این صورت اضافه کردم
[oracle@prod1 ~]$ srvctl  add database -db mciprod -oraclehome /oracle/product/12.2/db_1 -dbtype RAC  -spfile '+data/mciprod/PARAMETERFILE/spfile.268.1007145751' -role PRIMARY -diskgroup DATA,FRA
بعد از اضافه کردن دیتابس ما باید instacne هم اضافه کنیم
[oracle@prod1 ~]$ srvctl add instance -db MCIPROD -instance MCIPROD1 -n prod1
[oracle@prod1 ~]$ srvctl add instance -db MCIPROD -instance MCIPROD2 -n prod2
[oracle@prod1 ~]$ srvctl config database -db MCIPROD
Database unique name: mciprod1
Database name: MCIPROD1
Oracle home: /oracle/product/12.2/db_1
Oracle user: oracle
Spfile: +data/mciprod/PARAMETERFILE/spfile.268.1007145751
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: MCIPROD1,MCIPROD2
Configured nodes: prod1,prod2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
همان طور که مشاهده میکنیم کانفیگ ما انجام شده و دیتنابیس را start میکنیم
[oracle@prod1 ~]$ srvctl start database -db MCIPROD1

موفق و پیروز باشید.