Monday, November 15, 2021

Oracle 19c not working while switchGridHome to software-only installation

When the command " -switchGridHome" is used to perform Oracle database 19c out of place (OOP) patching, it will prompt to run on each cluster node. And will switch Grid Home from old one (without new patches) to new one (applied with new patches) on each node and also patch Grid Infrastructure Management Repository (GIMR) database on last node of the cluster.

Unfortunately, could only work on first node, and not on others if you deploy the software/patches in following steps,

Step 1. Install new GI home with software only option with command,

   ./ -applyRU <RU_Patch_Location> -applyOneOffs <comma_separated_one-off_patches_location>

At the end of the installation, you will be asked to run on each node. This software-only version does not touch old GI home and any running cluster processes (listener, asm, etc.). The new home is applied with new patctes (specified by command option applyRU and/or applyOneOffs).

Step 2. Switch GI from old home to new patched home with command,

   ./ -switchGridHome

This installation/configuration utility will create a new version of under directory "$ORACLE_HOME/crs/config" with home-switching and patching options enabled on local node (known as fist node), the affected options as following,
   Software-only version            New version
   ---------------------------      --------------------------
   PATCH_HOME=false                 PATCH_HOME=true
   MOVE_HOME=false                  MOVE_HOME=true
The is called by Technically, the utility should copy this new version of to all other nodes. However, it does not always happen and you will see nothing being changed by on nodes other than first node where the utility is running. This issue is experienced when new home is patches with Oracle Release Update

If does not work on other nodes, you can fix it by manually copying new version of from first node to other nodes.

Note: Always make a backup of existing before overriding it with new copied from first node and it is also a good practice to compare two versions of and verify what the differences are. 

No comments: