September 6, 2020

Oracle 19c Grid Infrastructure(GI) Rolling upgrade

I tested the Oracle Grid Infrastructure (GI) rolling upgrade from 12.2 to 19.8a few days back.

It's two node RAC cluster and the OS version is RHEL 7.6.


Followed the below steps to perform Rolling upgrade of Oracle Grid Infrastructure(GI) 

from 12.2 to 19.8:


  1. Ensure that the latest PSU is applied to 12.2 Grid Infrastructure (GI) home.

  1. Review/Configure Operating system for 19c upgrade:

Ensure that server is having the supported operating system version, kernel release and all the required operating system packages, for 19c upgrade.

The below Oracle document can be referred for more details.


  1. You need root user access to run “rootupgrade.sh” script during upgrade

  1. Create directory structure for Oracle 19c GI home:

mkdir -p /u01/app/19.3.0/grid
chown -R grid:oinstall /u01/app/19.3.0
chmod -R 775 /u01/app/19.3.0

  1. Download the Oracle 19c (19.3) Grid Infrastructure software, for Linux x86-64 to a directory (Example – “/oracle_software/19.3.0”)

  1. Extract downloaded 19c GI software in above step to 19c GI home directory created in above step # 4

cd /oracle_software/19.3.0/

unzip LINUX.X64_193000_grid_home.zip -d /u01/app/19.3.0/grid

  1. Download and extract the latest Oracle 19c GI RU patch to a working directory (“/oracle_software/19.3.0/31305339”).

I used the current available latest RU patch
"Patch 31305339: GI Release Update 19.8.0.0.200714" patch.

  1. Use Cluster Verification Utility (CVU) to perform pre-checks for upgrade

cd /u01/app/19.3.0/grid

./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/12.2.0.1/grid -dest_crshome /u01/app/19.3.0/grid -dest_version 19.0.0.0.0 -fixup -verbose

Review the Cluster Verification Utility (CVU) output and fix the errors/failures.

  1. Start the 19.8 Grid Infrastructure rolling upgrade as below:

The patch # 31305339 "GI Release Update 19.8" will be applied to the 19c GI home during upgrade.

Note - Ensure to set the environment, so that you can open the Graphical User Interface (GUI) for Oracle GI 19c installer.

$ unset ORACLE_BASE
$ unset ORACLE_HOME
$ unset ORACLE_SID

cd /u01/app/19.3.0/grid

./gridSetup.sh -applyPSU /oracle_software/19.3.0/31305339

Oracle Grid Infrastructure 19c Installer will start. There are 9 steps in the Installer.

Step 1 - Select Configuration option:
Choose “Upgrade Oracle Grid Infrastructure” and then click “Next”

Step 2 - Select all Cluster nodes and then click “Next”.

Step 3 - Specify Management options:
Update the details to perform registration with Enterprise Manager or uncheck and click “Next”.

Step 4 - Specify installation Location:
Review/Update Oracle Base and GI home path and then click “Next”.

Step 5 - Root script execution configuration:
            Uncheck “Automatically run configuration scripts” and then click “Next”.

Step 6 - Perform prerequisites check:
Review and fix if there are any errors. Click “Next” once there are no errors in the prerequisites check page.

Step 7 - Summary:
Review Summary and click “Submit”.

Step 8 - Install Product:
Installer will proceed with the upgrade.

Run “rootupgrade.sh” script, as root user, when installer prompts.
Run on local node first, after successful completion you can run on all other nodes in parallel.

Once the “rootupgrade.sh” script execution is completed on all nodes, come back to the Installer window and then click “OK” on the Installer UI window.

Step 9 - Finish
The rolling upgrade of Oracle Grid Infrastructure 19.8 completed successfully.
Completed all 9 steps of upgrade in GI 19c installer.
Click “Close”.

  1. Verify Grid infrastructure version using below commands, post upgrade:

$ <GI Home>/bin/crsctl query crs softwareversion -all

Oracle Clusterware version on node [Node1] is [19.0.0.0.0]
Oracle Clusterware version on node [Node2] is [19.0.0.0.0]

$ <GI Home>/bin/crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [19.0.0.0.0]

  1. Verify all GI services are online using below commands, post upgrade:

<GI Home>/bin/crsctl check crs
<GI Home>/bin/crsctl stat res -t

No comments:

Post a Comment