$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [12.2.0.1.0] $ crsctl query crs softwareversion -all Oracle Clusterware version on node [rhel12c1] is [12.2.0.1.0] Oracle Clusterware version on node [rhel12c2] is [12.2.0.1.0]1. As the first step for downgrade, remove the MGMTDB.
[grid@rhel12c1 ~]$ dbca -silent -deleteDatabase -sourceDB -MGMTDB Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/opt/app/oracle/cfgtoollogs/dbca/_mgmtdb.log" for further details.2. Run rootcrs.sh with downgrade option from any of the nodes
[root@rhel12c1 grid]# ./crs/install/rootcrs.sh -downgrade Using configuration parameter file: /opt/app/12.2.0/grid/crs/install/crsconfig_params The log of current session can be found at: /opt/app/oracle/crsdata/rhel12c1/crsconfig/crsdowngrade_rhel12c1_2017-09-25_04-26-42PM.log CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel12c1' CRS-2673: Attempting to stop 'ora.crsd' on 'rhel12c1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rhel12c1' CRS-2673: Attempting to stop 'ora.gns' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.std12c1.tbx.svc' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.qosmserver' on 'rhel12c1' CRS-2677: Stop of 'ora.std12c1.tbx.svc' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.std12c1.db' on 'rhel12c1' CRS-2677: Stop of 'ora.gns' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.std12c1.db' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.CLUSFS.dg' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.GIMR.dg' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.cvu' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.gns.vip' on 'rhel12c1' CRS-2677: Stop of 'ora.FRA.dg' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.GIMR.dg' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.CLUSFS.dg' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c1' CRS-2677: Stop of 'ora.MGMTLSNR' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rhel12c1' CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rhel12c1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.rhel12c1.vip' on 'rhel12c1' CRS-2677: Stop of 'ora.cvu' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c1' CRS-2677: Stop of 'ora.gns.vip' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.qosmserver' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.scan2.vip' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.scan3.vip' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.rhel12c1.vip' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c1' succeeded CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'rhel12c2' CRS-2672: Attempting to start 'ora.qosmserver' on 'rhel12c2' CRS-2672: Attempting to start 'ora.gns.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.cvu' on 'rhel12c2' CRS-2676: Start of 'ora.cvu' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.gns.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.gns' on 'rhel12c2' CRS-2676: Start of 'ora.MGMTLSNR' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.gns' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.scan2.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.scan3.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.rhel12c1.vip' on 'rhel12c2' CRS-2676: Start of 'ora.qosmserver' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.scan2.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.scan3.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.rhel12c1.vip' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rhel12c1' CRS-2677: Stop of 'ora.ons' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rhel12c1' CRS-2677: Stop of 'ora.net1.network' on 'rhel12c1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rhel12c1' has completed CRS-2677: Stop of 'ora.crsd' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.crf' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel12c1' CRS-2677: Stop of 'ora.drivers.acfs' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.crf' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rhel12c1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel12c1' CRS-2673: Attempting to stop 'ora.evmd' on 'rhel12c1' CRS-2677: Stop of 'ora.ctssd' on 'rhel12c1' succeeded CRS-2677: Stop of 'ora.evmd' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rhel12c1' CRS-2677: Stop of 'ora.cssd' on 'rhel12c1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel12c1' CRS-2677: Stop of 'ora.gipcd' on 'rhel12c1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel12c1' has completed CRS-4133: Oracle High Availability Services has been stopped. 2017/09/25 16:28:17 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:28:43 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:28:43 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:29:21 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:29:21 CLSRSC-591: successfully downgraded Oracle Clusterware stack on this node3. Run the downgrade from the last node.
[root@rhel12c2 grid]# ./crs/install/rootcrs.sh -downgrade Using configuration parameter file: /opt/app/12.2.0/grid/crs/install/crsconfig_params The log of current session can be found at: /opt/app/oracle/crsdata/rhel12c2/crsconfig/crsdowngrade_rhel12c2_2017-09-25_04-30-45PM.log CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crsd' on 'rhel12c2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rhel12c2' CRS-2673: Attempting to stop 'ora.std12c1.tbx.svc' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.qosmserver' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gns' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'rhel12c2' CRS-2677: Stop of 'ora.std12c1.tbx.svc' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.std12c1.db' on 'rhel12c2' CRS-2677: Stop of 'ora.gns' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.std12c1.db' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.CLUSFS.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.GIMR.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.cvu' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gns.vip' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.rhel12c1.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.GIMR.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.CLUSFS.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.FRA.dg' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2677: Stop of 'ora.qosmserver' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.cvu' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c2' CRS-2677: Stop of 'ora.rhel12c1.vip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.rhel12c2.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.gns.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.MGMTLSNR' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.scan3.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.scan2.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.rhel12c2.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rhel12c2' CRS-2677: Stop of 'ora.ons' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rhel12c2' CRS-2677: Stop of 'ora.net1.network' on 'rhel12c2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rhel12c2' has completed CRS-2677: Stop of 'ora.crsd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crf' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel12c2' CRS-2677: Stop of 'ora.drivers.acfs' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.crf' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.storage' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2677: Stop of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.evmd' on 'rhel12c2' CRS-2677: Stop of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rhel12c2' CRS-2677: Stop of 'ora.cssd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel12c2' CRS-2677: Stop of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crsd' on 'rhel12c2' CRS-2677: Stop of 'ora.crsd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crf' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel12c2' CRS-2677: Stop of 'ora.drivers.acfs' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.crf' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.storage' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2677: Stop of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.evmd' on 'rhel12c2' CRS-2677: Stop of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rhel12c2' CRS-2677: Stop of 'ora.cssd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel12c2' CRS-2677: Stop of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel12c2' CRS-2672: Attempting to start 'ora.evmd' on 'rhel12c2' CRS-2676: Start of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.evmd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel12c2' CRS-2676: Start of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'rhel12c2' CRS-2676: Start of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel12c2' CRS-2676: Start of 'ora.cssdmonitor' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rhel12c2' CRS-2672: Attempting to start 'ora.diskmon' on 'rhel12c2' CRS-2676: Start of 'ora.diskmon' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cssd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.ctssd' on 'rhel12c2' CRS-2676: Start of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rhel12c2' CRS-2676: Start of 'ora.asm' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.storage' on 'rhel12c2' CRS-2676: Start of 'ora.storage' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.crf' on 'rhel12c2' CRS-2676: Start of 'ora.crf' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rhel12c2' CRS-2676: Start of 'ora.crsd' on 'rhel12c2' succeeded CRS-6023: Starting Oracle Cluster Ready Services-managed resources CRS-2664: Resource 'ora.CLUSFS.dg' is already running on 'rhel12c2' CRS-2664: Resource 'ora.DATA.dg' is already running on 'rhel12c2' CRS-2664: Resource 'ora.FRA.dg' is already running on 'rhel12c2' CRS-2664: Resource 'ora.GIMR.dg' is already running on 'rhel12c2' CRS-6017: Processing resource auto-start for servers: rhel12c2 CRS-2672: Attempting to start 'ora.ons' on 'rhel12c2' CRS-2672: Attempting to start 'ora.cvu' on 'rhel12c2' CRS-2672: Attempting to start 'ora.qosmserver' on 'rhel12c2' CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'rhel12c2' CRS-2676: Start of 'ora.cvu' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.MGMTLSNR' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.ons' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.scan2.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.rhel12c2.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.scan1.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.scan3.vip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.rhel12c1.vip' on 'rhel12c2' CRS-2676: Start of 'ora.scan2.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.qosmserver' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.rhel12c2.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.scan1.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.scan3.vip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' CRS-2676: Start of 'ora.rhel12c1.vip' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.std12c1.db' on 'rhel12c2' CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.std12c1.db' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.std12c1.tbx.svc' on 'rhel12c2' CRS-2676: Start of 'ora.std12c1.tbx.svc' on 'rhel12c2' succeeded CRS-6016: Resource auto-start has completed for server rhel12c2 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crsd' on 'rhel12c2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rhel12c2' CRS-2673: Attempting to stop 'ora.qosmserver' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gns' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.std12c1.tbx.svc' on 'rhel12c2' CRS-2677: Stop of 'ora.std12c1.tbx.svc' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.std12c1.db' on 'rhel12c2' CRS-2677: Stop of 'ora.gns' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.std12c1.db' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.CLUSFS.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.GIMR.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.cvu' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gns.vip' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.rhel12c1.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.CLUSFS.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.FRA.dg' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.GIMR.dg' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c2' CRS-2677: Stop of 'ora.qosmserver' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.gns.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.cvu' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.MGMTLSNR' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.rhel12c1.vip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.rhel12c2.vip' on 'rhel12c2' CRS-2677: Stop of 'ora.scan3.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.scan2.vip' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.rhel12c2.vip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rhel12c2' CRS-2677: Stop of 'ora.ons' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rhel12c2' CRS-2677: Stop of 'ora.net1.network' on 'rhel12c2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rhel12c2' has completed CRS-2677: Stop of 'ora.crsd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crf' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel12c2' CRS-2677: Stop of 'ora.drivers.acfs' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.crf' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.evmd' on 'rhel12c2' CRS-2677: Stop of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rhel12c2' CRS-2677: Stop of 'ora.cssd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel12c2' CRS-2677: Stop of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' 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 'rhel12c2' CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel12c2' CRS-2676: Start of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.evmd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel12c2' CRS-2676: Start of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel12c2' CRS-2672: Attempting to start 'ora.gipcd' on 'rhel12c2' CRS-2676: Start of 'ora.cssdmonitor' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rhel12c2' CRS-2672: Attempting to start 'ora.diskmon' on 'rhel12c2' CRS-2676: Start of 'ora.diskmon' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cssd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.crf' on 'rhel12c2' CRS-2672: Attempting to start 'ora.ctssd' on 'rhel12c2' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2676: Start of 'ora.crf' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rhel12c2' CRS-2676: Start of 'ora.asm' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.storage' on 'rhel12c2' CRS-2676: Start of 'ora.storage' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rhel12c2' CRS-2676: Start of 'ora.crsd' on 'rhel12c2' succeeded CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crsd' on 'rhel12c2' CRS-2677: Stop of 'ora.crsd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.crf' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel12c2' CRS-2677: Stop of 'ora.drivers.acfs' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.crf' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.storage' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rhel12c2' CRS-2677: Stop of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.asm' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel12c2' CRS-2673: Attempting to stop 'ora.evmd' on 'rhel12c2' CRS-2677: Stop of 'ora.evmd' on 'rhel12c2' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rhel12c2' CRS-2677: Stop of 'ora.cssd' on 'rhel12c2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel12c2' CRS-2677: Stop of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel12c2' 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 'rhel12c2' CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel12c2' CRS-2676: Start of 'ora.evmd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.mdnsd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel12c2' CRS-2676: Start of 'ora.gpnpd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel12c2' CRS-2672: Attempting to start 'ora.gipcd' on 'rhel12c2' CRS-2676: Start of 'ora.cssdmonitor' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.gipcd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rhel12c2' CRS-2672: Attempting to start 'ora.diskmon' on 'rhel12c2' CRS-2676: Start of 'ora.diskmon' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cssd' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rhel12c2' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rhel12c2' CRS-2672: Attempting to start 'ora.ctssd' on 'rhel12c2' CRS-2674: Start of 'ora.drivers.acfs' on 'rhel12c2' failed CRS-2676: Start of 'ora.ctssd' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rhel12c2' CRS-2676: Start of 'ora.asm' on 'rhel12c2' succeeded 2017/09/25 16:39:54 CLSRSC-338: Successfully downgraded OCR to version 12.1.0.2.0 CRS-2672: Attempting to start 'ora.crf' on 'rhel12c2' CRS-2672: Attempting to start 'ora.storage' on 'rhel12c2' CRS-2676: Start of 'ora.storage' on 'rhel12c2' succeeded CRS-2676: Start of 'ora.crf' on 'rhel12c2' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rhel12c2' CRS-2676: Start of 'ora.crsd' on 'rhel12c2' succeeded 2017/09/25 16:40:24 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:40:50 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:40:50 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:41:25 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2017/09/25 16:41:25 CLSRSC-591: successfully downgraded Oracle Clusterware stack on this node 2017/09/25 16:41:25 CLSRSC-640: To complete the downgrade operation, ensure that the node inventory on all nodes points to the configured Grid Infrastructure home '/opt/app/12.1.0/grid2'. 2017/09/25 16:41:27 CLSRSC-592: Run 'crsctl start crs' from home /opt/app/12.1.0/grid2 on each node to complete downgrade.
4. Upgrade the oracle inventory by removing the CRS association from 12.2 GI home and adding it to 12.1 home.
[grid@rhel12c1 bin]$ pwd /opt/app/12.2.0/grid/oui/bin ./runInstaller -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=false ORACLE_HOME=/opt/app/12.2.0/grid "CLUSTER_NODES=rhel12c1,rhel12c2" -doNotUpdateNodeList Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 5119 MB Passed The inventory pointer is located at /etc/oraInst.loc 'UpdateNodeList' was successful. [grid@rhel12c1 bin]$ pwd /opt/app/12.1.0/grid2/oui/bin ./runInstaller -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true ORACLE_HOME=/opt/app/12.1.0/grid2 "CLUSTER_NODES=rhel12c1,rhel12c2" Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 5119 MB Passed The inventory pointer is located at /etc/oraInst.loc 'UpdateNodeList' was successful.Verify the update on inventory.xml
<HOME NAME="OraGI12Home1" LOC="/opt/app/12.1.0/grid2" TYPE="O" IDX="1" CRS="true"> <NODE_LIST> <NODE NAME="rhel12c1"/> <NODE NAME="rhel12c2"/> </NODE_LIST> </HOME> <HOME NAME="OraGI12Home2" LOC="/opt/app/12.2.0/grid" TYPE="O" IDX="3"/>5. If the /etc/oratab is missing any ASM references with downgraded 12.1 GI home, add the entries manually.
6. Before re-creatign the 12.1 MGMTDB check if there's any references to mgmtdb (using crsctl stat res -t). If there are any references then recreating the MGMTDB will fail with
PRCD-1000 : Database _mgmtdb already exists PRCR-1086 : resource ora.mgmtdb is already registeredmgmtdb could be removed with
srvctl remove mgmtdb Remove the database _mgmtdb? (y/[n]) y7. Once all residual information on mgmtdb is removed create the MGMTDB root container.
[grid@rhel12c1 ~]$ $GI_HOME/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName +GIMR -datafileJarLocation $GI_HOME/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck Registering database with Oracle Grid Infrastructure 5% complete Copying database files 7% complete 9% complete 16% complete 23% complete 30% complete 37% complete 41% complete Creating and starting Oracle instance 43% complete 48% complete 49% complete 50% complete 55% complete 60% complete 61% complete 64% complete Completing Database Creation 68% complete 79% complete 89% complete 100% complete Look at the log file "/opt/app/oracle/cfgtoollogs/dbca/_mgmtdb/_mgmtdb3.log" for further details.8. Create the PDB inside the MGMTDB root. The PDB should be named same as the cluster name. Cluster name could be found out with
$ cemutlo -n prod-clusterIf cluster name has a dash (-) then when specify the PDB name replace the dash (-) with an underscore (_). Without this change the creation of the PDB will fail. More on this was mentioned on an earlier post.
[grid@rhel12c1 ~]$ $GI_HOME/bin/dbca -silent -createPluggableDatabase -sourceDB -MGMTDB -pdbName prod_cluster -createPDBFrom RMANBACKUP -PDBBackUpfile $GI_HOME/assistants/dbca/templates/mgmtseed_pdb.dfb -PDBMetadataFile $GI_HOME/assistants/dbca/templates/mgmtseed_pdb.xml -createAsClone true -internalSkipGIHomeCheck 4% complete 12% complete 21% complete 38% complete 55% complete 85% complete Completing Pluggable Database Creation 100% complete Look at the log file "/opt/app/oracle/cfgtoollogs/dbca/_mgmtdb/prod_cluster/_mgmtdb0.log" for further details.9. Finally run mgmtca and verify mgmtdb resoruce is available
run mgmtca ora.mgmtdb 1 ONLINE ONLINE rhel12c1 Open,STABLE10. As mentioned in upgarde to 12.2 the SCAN name changes if GNS is used. This cluster uses GNS. Check if the SCAN name has been reverted back to 12.1 format.
srvctl config scan SCAN name: prod-cluster-scan.rac.domain.net, Network: 1 Subnet IPv4: 192.168.0.0/255.255.255.0/eth0, dhcp Subnet IPv6: SCAN 0 IPv4 VIP: -/scan1-vip/192.168.0.92 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 1 IPv4 VIP: -/scan2-vip/192.168.0.89 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 2 IPv4 VIP: -/scan3-vip/192.168.0.90 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes:This concludes the downgrade to 12.1.0.2 from 12.2.0.1
Related posts
Downgrade Grid Infrastructure from 12.2.0.1 to 11.2.0.4
Downgrade Grid Infrastructure from 12.1.0.2 to 11.2.0.4
Downgrade Grid Infrastructure from 11.2.0.4 to 11.2.0.3
Downgrade Grid Infrastructure from 11.2.0.4 to 11.1.0.7
Useful metalink notes
How to Upgrade to/Downgrade from Grid Infrastructure 12.2 and Known Issues [ID 2240959.1]