How to Patch Oracle Grid Infrastructure and DB Home to 19.29 RU — A Practical Walkthrough

Ensuring Stability: Pre-Patching Verification and Backup Planning

OS Version:

cat /etc/redhat-release

ORACLE_HOME & GRID_HOME:

cat /etc/oratab

PMON :

ps -ef | grep pmon

Identifying the Patch Level on an ASM Instance: Connected To:

Identifying the Patch Level on an DB Instance: Connected To:

Comprehensive Backup of Grid and Oracle Home Before Patching

tar -cpf /u01/backup/bkup_Db_home.tar /u01/app/oracle/product/19.0.0/dbhome_1

tar -cpf /u01/backup/bkup_Grid_home.tar /u01/app/19.0.0/grid

Obtaining the Necessary RU Patch from MOS

p38298204_190000_Linux-x86–64.zip — SYSTEM PATCH OCW & p6880880_190000_Linux-x86–64.zip -OPATCH

Decompressing the OCW Patch Bundle

unzip -o p38298204_190000_Linux-x86–64.zip

Ensuring Compatibility: OPatch Validation & Upgrade for Grid and Oracle Home

$ORACLE_HOME/OPatch/opatch version-Grid Home

$ORACLE_HOME/OPatch/opatch version-Oracle home

Secure the Old OPatch and Unpack the Latest OPatch Utility-Grid Home

Secure the Old OPatch and Unpack the Latest OPatch Utility-Oracle home

OPatch Conflict Analysis for Grid Infrastructure and Database Home

Set home to Grid home Run the Conflict Analysis

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38291812

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38322923

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38311528

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38380425

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/36758186

Set home to DB home Run the Conflict Analysis

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38291812

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/19.29_RU/patches/38298204/38322923

Validating OCW Patch Bundle Through a Dry Run

Log in as the root user, export the Grid Home path, and run the analyze command to perform the validation

opatchauto apply /opt/19.29_RU/patches/38298204 -analyze

OCW Patch Bundle Application Procedure & Post-Patch Verification

opatchauto apply /opt/19.29_RU/patches/38298204

opatch auto simplifies the entire patching lifecycle for both the Grid Infrastructure home and the Oracle Home. Instead of manually stopping services, applying patches, and bringing components back online, the utility automates every step. It gracefully shuts down the necessary Cluster ware and database services, applies the patch in the correct sequence, and then restarts the databases and Cluster ware components once the update is complete

Identifying the Patch Level on an ASM Instance: Connected To:

Identifying the Patch Level on an DB Instance: Connected To: