Monday, August 6, 2018

Upgrading Grid Infrastructure and RDBMS from Oracle 12cR2 (12.2.0) to Oracle 18c in Oracle Exadata x7-2


I have covered major steps here.

Please refer for more details and pre-reqs 
https://mikedietrichde.com/2018/06/18/upgrade-oracle-12-2-0-1-to-oracle-database-18c-on-premises/

Patches to apply before upgrading Oracle GI and DB to 18c or downgrading to previous release (Doc ID 2414935.1)

1. If you have applied the below Jan 2018 PSU Patch on Oracle 12cR2 (12.2.0) it's good to go. It's includes the patch "27006180".
 a. p27100009_122010_Linux-x86-64.zip (GI patch)
 b. p27105253_122010_Linux-x86-64.zip (RDBMS patch)

[grid@rac1-12cr2 OPatch]$ ./opatch lsinventory | grep 27006180
     27068526, 27006180, 26755613, 26433979, 25698636, 25644425, 26664476

Note: If not applied above patches while upgrade we will get pre-reqs screen to apply the below patch
 a. p27006180_122010_Linux-x86-64.zip



After Jan 2018 PSU Patch Installation 




Node-1: rac1-12cr2
=====================
[root@rac1-12cr2 ~]# sh /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@rac1-12cr2 ~]#
[root@rac1-12cr2 ~]# exit

Node-2: rac2-12cr2
=====================
[root@rac2-12cr2 ~]# sh /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@rac2-12cr2 ~]#

Node-1: rac1-12cr2 (rootupgrade.sh)
=====================================
[root@rac1-12cr2 ~]# sh /u01/app/18.0.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/18.0.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/18.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/rac1-12cr2/crsconfig/rootcrs_rac1-12cr2_2018-08-06_10-30-08PM.log
2018/08/06 22:30:32 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.
2018/08/06 22:30:32 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/08/06 22:32:14 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/08/06 22:32:14 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.
2018/08/06 22:32:26 CLSRSC-595: Executing upgrade step 3 of 19: 'GetOldConfig'.
2018/08/06 22:32:26 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/08/06 22:32:40 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2018/08/06 22:34:19 CLSRSC-693: CRS entities validation completed successfully.
2018/08/06 22:34:26 CLSRSC-515: Starting OCR manual backup.
2018/08/06 22:34:38 CLSRSC-516: OCR manual backup successful.
2018/08/06 22:34:47 CLSRSC-486:
 At this stage of upgrade, the OCR has changed.
 Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.
2018/08/06 22:34:48 CLSRSC-541:
 To downgrade the cluster:
 1. All nodes that have been upgraded must be downgraded.
2018/08/06 22:34:48 CLSRSC-542:
 2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2018/08/06 22:34:48 CLSRSC-615:
 3. The last node to downgrade cannot be a Leaf node.
2018/08/06 22:34:59 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/08/06 22:34:59 CLSRSC-595: Executing upgrade step 4 of 19: 'GenSiteGUIDs'.
2018/08/06 22:35:02 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.
2018/08/06 22:35:08 CLSRSC-363: User ignored prerequisites during installation
2018/08/06 22:35:21 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.
2018/08/06 22:35:35 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.
2018/08/06 22:35:35 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.
2018/08/06 22:37:17 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode
2018/08/06 22:37:17 CLSRSC-482: Running command: '/u01/app/12.2.0/grid/bin/crsctl start rollingupgrade 18.0.0.0.0'
CRS-1131: The cluster was successfully set to rolling upgrade mode.
2018/08/06 22:37:21 CLSRSC-482: Running command: '/u01/app/18.0.0/grid/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u01/app/12.2.0/grid 
-oldCRSVersion 12.2.0.1.0 -firstNode true -startRolling false '

ASM configuration upgraded in local node successfully.

2018/08/06 22:37:54 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode
2018/08/06 22:38:02 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2018/08/06 22:38:56 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2018/08/06 22:39:05 CLSRSC-595: Executing upgrade step 9 of 19: 'CheckCRSConfig'.
2018/08/06 22:39:06 CLSRSC-595: Executing upgrade step 10 of 19: 'UpgradeOLR'.
2018/08/06 22:39:25 CLSRSC-595: Executing upgrade step 11 of 19: 'ConfigCHMOS'.
2018/08/06 22:39:25 CLSRSC-595: Executing upgrade step 12 of 19: 'UpgradeAFD'.
2018/08/06 22:41:17 CLSRSC-595: Executing upgrade step 13 of 19: 'createOHASD'.
2018/08/06 22:41:34 CLSRSC-595: Executing upgrade step 14 of 19: 'ConfigOHASD'.
2018/08/06 22:41:34 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2018/08/06 22:42:30 CLSRSC-595: Executing upgrade step 15 of 19: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1-12cr2'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1-12cr2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/08/06 22:43:39 CLSRSC-595: Executing upgrade step 16 of 19: 'InstallKA'.
2018/08/06 22:43:57 CLSRSC-595: Executing upgrade step 17 of 19: 'UpgradeCluster'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1-12cr2'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1-12cr2' 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.evmd' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1-12cr2'
CRS-2676: Start of 'ora.evmd' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1-12cr2'
CRS-2676: Start of 'ora.gpnpd' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1-12cr2'
CRS-2676: Start of 'ora.gipcd' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1-12cr2'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.cssd' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1-12cr2'
CRS-2676: Start of 'ora.diskmon' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.crf' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.ctssd' on 'rac1-12cr2'
CRS-2676: Start of 'ora.ctssd' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac1-12cr2'
CRS-2676: Start of 'ora.crsd' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac1-12cr2'
CRS-2676: Start of 'ora.asm' on 'rac1-12cr2' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: rac1-12cr2
CRS-2673: Attempting to stop 'ora.rac1-12cr2.vip' on 'rac2-12cr2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2-12cr2'
CRS-2672: Attempting to start 'ora.ons' on 'rac1-12cr2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2-12cr2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2-12cr2'
CRS-2677: Stop of 'ora.rac1-12cr2.vip' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.rac1-12cr2.vip' on 'rac1-12cr2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac1-12cr2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac1-12cr2'
CRS-2676: Start of 'ora.ons' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac1-12cr2' succeeded
CRS-2676: Start of 'ora.rac1-12cr2.vip' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac1-12cr2'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac1-12cr2'
CRS-2676: Start of 'ora.asm' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'rac1-12cr2'
CRS-2676: Start of 'ora.DATA.dg' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.orcl.db' on 'rac1-12cr2'
CRS-2674: Start of 'ora.orcl.db' on 'rac1-12cr2' failed
CRS-2679: Attempting to clean 'ora.orcl.db' on 'rac1-12cr2'
CRS-2678: 'ora.orcl.db' on 'rac1-12cr2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-5802: Unable to start the agent process
CRS-6016: Resource auto-start has completed for server rac1-12cr2
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/08/06 22:57:33 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 12c Release 2.
Successfully taken the backup of node specific configuration in OCR.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2018/08/06 22:57:58 CLSRSC-595: Executing upgrade step 18 of 19: 'UpgradeNode'.
2018/08/06 22:58:04 CLSRSC-474: Initiating upgrade of resource types
2018/08/06 22:58:34 CLSRSC-475: Upgrade of resource types successfully initiated.
2018/08/06 22:58:53 CLSRSC-595: Executing upgrade step 19 of 19: 'PostUpgrade'.
2018/08/06 22:59:02 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@rac1-12cr2 ~]#

Node-2: rac2-12cr2 (rootupgrade.sh)
======================================

[root@rac2-12cr2 ~]# sh /u01/app/18.0.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/18.0.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/18.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/rac2-12cr2/crsconfig/rootcrs_rac2-12cr2_2018-08-06_11-01-13PM.log
2018/08/06 23:01:21 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.
2018/08/06 23:01:21 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/08/06 23:03:02 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/08/06 23:03:02 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.
2018/08/06 23:03:04 CLSRSC-595: Executing upgrade step 3 of 19: 'GetOldConfig'.
2018/08/06 23:03:05 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/08/06 23:04:34 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/08/06 23:04:34 CLSRSC-595: Executing upgrade step 4 of 19: 'GenSiteGUIDs'.
2018/08/06 23:04:34 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.
2018/08/06 23:04:35 CLSRSC-363: User ignored prerequisites during installation
2018/08/06 23:04:37 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.
2018/08/06 23:04:39 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.
2018/08/06 23:04:40 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.

ASM configuration upgraded in local node successfully.

2018/08/06 23:05:11 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2018/08/06 23:06:10 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2018/08/06 23:07:29 CLSRSC-595: Executing upgrade step 9 of 19: 'CheckCRSConfig'.
2018/08/06 23:07:30 CLSRSC-595: Executing upgrade step 10 of 19: 'UpgradeOLR'.
2018/08/06 23:07:34 CLSRSC-595: Executing upgrade step 11 of 19: 'ConfigCHMOS'.
2018/08/06 23:07:34 CLSRSC-595: Executing upgrade step 12 of 19: 'UpgradeAFD'.
2018/08/06 23:09:10 CLSRSC-595: Executing upgrade step 13 of 19: 'createOHASD'.
2018/08/06 23:09:11 CLSRSC-595: Executing upgrade step 14 of 19: 'ConfigOHASD'.
2018/08/06 23:09:11 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2018/08/06 23:09:40 CLSRSC-595: Executing upgrade step 15 of 19: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2-12cr2'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2-12cr2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/08/06 23:10:34 CLSRSC-595: Executing upgrade step 16 of 19: 'InstallKA'.
2018/08/06 23:10:35 CLSRSC-595: Executing upgrade step 17 of 19: 'UpgradeCluster'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2-12cr2'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2-12cr2' 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.evmd' on 'rac2-12cr2'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac2-12cr2'
CRS-2676: Start of 'ora.mdnsd' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.evmd' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac2-12cr2'
CRS-2676: Start of 'ora.gpnpd' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'rac2-12cr2'
CRS-2676: Start of 'ora.gipcd' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2-12cr2'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'rac2-12cr2'
CRS-2672: Attempting to start 'ora.cssd' on 'rac2-12cr2'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac2-12cr2'
CRS-2676: Start of 'ora.diskmon' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.crf' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac2-12cr2'
CRS-2672: Attempting to start 'ora.ctssd' on 'rac2-12cr2'
CRS-2676: Start of 'ora.ctssd' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rac2-12cr2'
CRS-2676: Start of 'ora.crsd' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac2-12cr2'
CRS-2676: Start of 'ora.asm' on 'rac2-12cr2' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: rac2-12cr2
CRS-2673: Attempting to stop 'ora.rac2-12cr2.vip' on 'rac1-12cr2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.ons' on 'rac2-12cr2'
CRS-2677: Stop of 'ora.rac2-12cr2.vip' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.rac2-12cr2.vip' on 'rac2-12cr2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1-12cr2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1-12cr2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1-12cr2' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2-12cr2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2-12cr2'
CRS-2676: Start of 'ora.ons' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2-12cr2' succeeded
CRS-2676: Start of 'ora.rac2-12cr2.vip' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac2-12cr2'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rac2-12cr2'
CRS-2676: Start of 'ora.asm' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'rac2-12cr2'
CRS-2676: Start of 'ora.DATA.dg' on 'rac2-12cr2' succeeded
CRS-2672: Attempting to start 'ora.orcl.db' on 'rac1-12cr2'
CRS-2672: Attempting to start 'ora.orcl.db' on 'rac2-12cr2'
CRS-2674: Start of 'ora.orcl.db' on 'rac1-12cr2' failed
CRS-2679: Attempting to clean 'ora.orcl.db' on 'rac1-12cr2'
CRS-2674: Start of 'ora.orcl.db' on 'rac2-12cr2' failed
CRS-2679: Attempting to clean 'ora.orcl.db' on 'rac2-12cr2'
CRS-2678: 'ora.orcl.db' on 'rac1-12cr2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-2678: 'ora.orcl.db' on 'rac2-12cr2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-5802: Unable to start the agent process
===== Summary of resource auto-start failures follows =====
CRS-2807: Resource 'ora.orcl.db' failed to start automatically.
CRS-6016: Resource auto-start has completed for server rac2-12cr2
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/08/06 23:24:09 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 12c Release 2.
Successfully taken the backup of node specific configuration in OCR.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2018/08/06 23:25:43 CLSRSC-595: Executing upgrade step 18 of 19: 'UpgradeNode'.
Start upgrade invoked..
2018/08/06 23:25:52 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2018/08/06 23:25:52 CLSRSC-482: Running command: '/u01/app/18.0.0/grid/bin/crsctl set crs activeversion'
Started to upgrade the active version of Oracle Clusterware. This operation may take a few minutes.
Started to upgrade CSS.
CSS was successfully upgraded.
Started to upgrade Oracle ASM.
Started to upgrade CRS.
CRS was successfully upgraded.
Successfully upgraded the active version of Oracle Clusterware.
Oracle Clusterware active version was successfully set to 18.0.0.0.0.
2018/08/06 23:26:59 CLSRSC-479: Successfully set Oracle Clusterware active version
2018/08/06 23:26:59 CLSRSC-476: Finishing upgrade of resource types
2018/08/06 23:27:00 CLSRSC-477: Successfully completed upgrade of resource types
2018/08/06 23:28:57 CLSRSC-595: Executing upgrade step 19 of 19: 'PostUpgrade'.
2018/08/06 23:29:21 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@rac2-12cr2 ~]#

Check the Version

[grid@rac1-12cr2 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [18.0.0.0.0]
[grid@rac1-12cr2 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [rac1-12cr2] is [18.0.0.0.0]
[grid@rac1-12cr2 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [18.0.0.0.0]
[grid@rac1-12cr2 ~]$

[grid@rac2-12cr2 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM2
ORACLE_HOME = [/home/oracle] ? /u01/app/18.0.0/grid
The Oracle base has been set to /u01/app/grid
[grid@rac2-12cr2 ~]$
[grid@rac2-12cr2 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [18.0.0.0.0]
[grid@rac2-12cr2 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [rac2-12cr2] is [18.0.0.0.0]
[grid@rac2-12cr2 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [18.0.0.0.0]
[grid@rac2-12cr2 ~]$


I will post RDBMS major steps for upgrade shortly ......



No comments:

Post a Comment