سلام
یکی از دوستان درخواست تغییر 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
موفق و پیروز باشید.