How to Upgrade Oracle Grid Infrastructure from 12c to 19c Version in RAC environment with minimal downtime

 

How to Upgrade Oracle Grid Infrastructure from 12c to 19c Version in RAC environment with minimal downtime

Donatien MBADI

Aug. 2020

Overview

This article describes the process to upgrade a 2-nodes Oracle 12c R2 Grid Infrastructure to Oracle 19c on Linux OEL7. The upgrade is performed in a rolling fashion using batches which will limit the application downtime.

Create a new home for GI 19c and unzip the grid software

The actual 12c directory structures are as below:

ORACLE_BASE= /u01/app/grid

ORACLE_HOME=/u01/12.2.0/grid

 

The target directories will be:

ORACLE_BASE= /u01/app/grid_2  à to remove

ORACLE_HOME=/u01/19.3.0/grid

 

On both nodes as root, create the new directories:

[root@uat-entdbrac06 ~]# mkdir -p /u01/app/grid_2 à to remove

[root@uat-entdbrac06 ~]# mkdir -p /u01/19.3.0/grid

 

[root@uat-entdbrac06 ~]# chown -R grid:oinstall /u01/app/grid_2 à to remove

[root@uat-entdbrac06 ~]#

[root@uat-entdbrac06 ~]# chown -R grid:oinstall /u01/19.3.0/grid

 

[grid@uat-entdbrac05]$ cd /u01/19.3.0/grid

[grid@uat-entdbrac05 grid]$ unzip -q /home/grid/LINUX.X64_193000_grid_home.zip

 

Install the packages kmod, kmod-libs, libvirt and libvirt-devel (if there are not already installed)

[root@uat-entdbrac05 ~]# yum install kmod

 [root@uat-entdbrac05 ~]# yum install kmod-libs

 [root@uat-entdbrac05 ~]# yum install -y libvirt

[root@uat-entdbrac05 ~]# yum install -y  libvirt-devel

 

Check current Oracle Clusterware installation readiness for upgrades using Cluster Verification Utility (CVU)

From the 19c Grid Infrastructure home, run this command:

[grid@uat-entdbrac05 grid]$ /u01/19.3.0/grid/runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/12.2.0/grid -dest_crshome /u01/19.3.0/grid -dest_version 19.0.0.0.0 -fixup

Update Opatch version and apply patches 31305382

[root@uat-entdbrac05 ~]# /u01/12.2.0/grid/OPatch/opatch version

OPatch Version: 12.2.0.1.6

OPatch succeeded.

[root@uat-entdbrac05 ~]#

You must use the OPatch utility version 12.2.0.1.5 or later to apply this patch. Oracle recommends that you use the latest released OPatch for 12.1 releases, which is available for download from My Oracle Support patch 6880880. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.

 

 

Start the 19c Grid Infrastructure rolling upgrade

 

[grid@uat-entdbrac05 ~]$ export DISPLAY=10.159.20.104:0.0

[grid@uat-entdbrac05 ~]$

[grid@uat-entdbrac05 ~]$ cd /u01/19.3.0/grid/

[grid@uat-entdbrac05 grid]$

Download patch 31305339

As grid user, set the DISPLAY and run the below

$/u01/19.3.0/grid/gridSetup.sh -applyRU /u01/softs/31305339 -J-Doracle.install.mgmtDB=false -J-Doracle.install.mgmtDB.CDB=false -J Doracle.install.crs.enableRemoteGIMR=false