Oracle DBA

Upgrading Oracle Grid Infrastructure from version 11.2.0.4 to 12.2.0.1 involves several steps and considerations.

You need to have Oracle Grid software for upgrading Oracle grid along with patches.

General steps followed for this upgrade,

1. Upload grid software to the directory where you want to have GRID_HOME for your 12c environment.
2. run cluster verification utility and check any changes need to be done to the systems.
3. ./runcluvfy.sh and with GUI follow the onscreen instructions.

You need to create same directory structure for your GRID_HOME on all RAC nodes.  Also for this upgrade Oracle need at least 30GB space free in OCR disk group.

./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/11.2.0/grid_1 -dest_crshome /u01/app/12c -dest_version 12.2.0.1.0 -fixup -verbose

Below is the output received from above command, I had added only failed one staements.

[oracle@rac1prod 12c]$ ./runcluvfy.sh stage -pre crsinst -upgrade -rolling 
-src_crshome /u01/app/11.2.0/grid_1 -dest_crshome /u01/app/12c -dest_version 12.2.0.1.0 -fixup -verbose

Verifying Physical Memory ...
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
rac2prod 7.5279GB (7893580.0KB) 8GB (8388608.0KB) failed
rac1prod 7.5279GB (7893580.0KB) 8GB (8388608.0KB) failed
Verifying Physical Memory ...FAILED (PRVF-7530)

.

.

Verifying Oracle patch:17617807 ...
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac1prod missing 17617807 failed
rac2prod missing 17617807 failed
Verifying Oracle patch:17617807 ...FAILED (PRVG-1261)
Verifying Oracle patch:21255373 ...
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac1prod missing 21255373 failed
rac2prod missing 21255373 failed
Verifying Oracle patch:21255373 ...FAILED (PRVG-1261)

.

.

Verifying Package: ksh ...
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
rac2prod missing ksh failed
rac1prod missing ksh failed
Verifying Package: ksh ...FAILED (PRVF-7532)

.

.

Verifying Disk group ASM compatibility setting ...FAILED (PRVE-3175)

.

.

Failures were encountered during execution of CVU verification request "stage -pre crsinst".

Verifying Physical Memory ...FAILED
rac2prod: PRVF-7530 : Sufficient physical memory is not available on node
"rac2prod" [Required physical memory = 8GB (8388608.0KB)]

rac1prod: PRVF-7530 : Sufficient physical memory is not available on node
"rac1prod" [Required physical memory = 8GB (8388608.0KB)]

Verifying Oracle patch:17617807 ...FAILED
rac2prod: PRVG-1261 : Required Oracle patch "17617807" in home
"/u01/app/11.2.0/grid_1" is not found on node "rac2prod".

rac1prod: PRVG-1261 : Required Oracle patch "17617807" in home
"/u01/app/11.2.0/grid_1" is not found on node "rac1prod".

Verifying Oracle patch:21255373 ...FAILED
rac2prod: PRVG-1261 : Required Oracle patch "21255373" in home
"/u01/app/11.2.0/grid_1" is not found on node "rac2prod".

rac1prod: PRVG-1261 : Required Oracle patch "21255373" in home
"/u01/app/11.2.0/grid_1" is not found on node "rac1prod".

Verifying Package: ksh ...FAILED
rac2prod: PRVF-7532 : Package "ksh" is missing on node "rac2prod"

rac1prod: PRVF-7532 : Package "ksh" is missing on node "rac1prod"

Verifying Disk group ASM compatibility setting ...FAILED
DATA: PRVE-3175 : ASM compatibility for ASM disk group "DATA" is set to
"11.2.0.0.0", which is less than the minimum supported value "11.2.0.2.0".

FRA: PRVE-3175 : ASM compatibility for ASM disk group "FRA" is set to
"11.2.0.0.0", which is less than the minimum supported value "11.2.0.2.0".

OCR: PRVE-3175 : ASM compatibility for ASM disk group "OCR" is set to
"11.2.0.0.0", which is less than the minimum supported value "11.2.0.2.0".


CVU operation performed: stage -pre crsinst
Date: Jun 2, 2023 4:25:59 AM
CVU home: /u01/app/12c/
User: oracle
[oracle@rac1prod 12c]$

I ignored memory related check.

I applied opatch 17617807, I unzipped the file and below is the log, (you need to have your cluster up and running, and opatch auto will take care of all, patch will be applied to all nodes of RAC.

[root@rac1stby ~]# opatch auto /u01/app/software/opatch/17617807 -oh /u01/app/11.2.0/grid -ocmrf /u01/app/11.2.0/grid/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/software/opatch -patchn 17617807 -oh /u01/app/11.2.0/grid -ocmrf /u01/app/11.2.0/grid/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-06-05_15-12-27.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-06-05_15-12-27.report.log

2023-06-05 15:12:27: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully


Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.
[root@rac1stby ~]#

For installing 21255373 opatch need to be updated with latest version.  Below was the log for my opatch utility,

[root@rac1stby ~]# which opatch
/u01/app/11.2.0/grid/OPatch/opatch
[root@rac1stby ~]# opatch version
OPatch Version: 11.2.0.3.41

OPatch succeeded.
[root@rac1stby ~]#

I had applied 21255373 with opatch apply command.

ksh rpm is installed by putting installation CD in drive and running rpm -UVH ksh-***.rpm

ASM disk compatibility can be changed with asmca tool or with below command on asm instance

SQL> ALTER DISKGROUP OCR SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2.0′;

Diskgroup altered.

SQL> ALTER DISKGROUP DATA SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2.0′;

Diskgroup altered.

SQL> ALTER DISKGROUP FRA SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2.0′;

Diskgroup altered.

SQL>

Though everything is set after running ./gridSetup.sh at the end you will see error in precheck for Memory and 17617807 / 21255373 patches, so you need to run setup with below command,

./gridSetup.sh -skipPrereqs

Run rootUpgrade.sh from each node, once finished click OK on GUI to complete post tasks.

That’s it!