Patching my 19c environment with Oct 2022 RU

Patching Oracle environment with October, 2022 Release Update

Oracle has released the Oct 2022 patch set for all the supported version. Below is the patch information for Oracle 19c.

34416665 - Grid Infrastructure Release Update 19.17.0.0.221018
34419443 - Database Release Update 19.17.0.0.221018
34411846 - OJVM Release Update 19.17.0.0.221018

In this post, we will see how we can apply the Grid and Database RUs in my Lab environment.

Source Environment setup :

RAC Database : LABDBPR ( labdbpr1 and labdbpr2) 

GRID Home         : /u01/app/19.3.0.0/grid

RDBMS Home       : /u01/app/oracle/product/19.14.0.0/dbhome_1

Version                 : Oracle Database 19c EE - Production Version 19.16.0.0.0

hosts : oraprim01 & oraprim02

My Lab environment is a 2 node RAC cluster with patch set 19.16 applied. 

 

Download the Grid Patch , Database patch and the latest OPatch from Oracle and stage it on all the nodes of the cluster(if its RAC)

p34416665_190000_Linux-x86-64.zip - Grid Infrastructure Release Update 19.17.0.0.221018
p34419443_190000_Linux-x86-64.zip - Database Release Update 19.17.0.0.221018
p6880880_190000_Linux-x86-64.zip   - Latest Opatch for 19c

The Oracle Grid Infrastructure and  Database patches are cumulative and include the database CPU program security content.

Patch Installation 

Patch Installation prerequisites

1. Opatch utility version information : You must use the OPatch utility version 12.2.0.1.32 or later to apply this patch.

Download and unzip the latest OPatch utility to both the Grid and Database homes.

Grid home : 

As Root user id, perform below steps.

[root@oraprim01 software]# mv /u01/app/19.3.0.0/grid/OPatch /u01/app/19.3.0.0/grid/OPatch.old

[root@oraprim01 software]# unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0.0/grid/

[root@oraprim01 software]# chown -Rf oracle:dba /u01/app/19.3.0.0/grid/OPatch

Database home

As Oracle user id, perform below steps.

[oracle@oraprim01 software]$mv /u01/app/oracle/product/19.3.0.0/dbhome_1/OPatch /u01/app/oracle/product/19.3.0.0/dbhome_1/OPatch.old

[oracle@oraprim01 software]$unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0.0/dbhome_1/

2. Check the consistency for the Oracle inventory of both Grid and Database homes

Before we begin apply any patches, it is always strongly  recommended to check the consistency of the inventory information for both the Grid home and Oracle homes where we are applying the patch. 

3. Run the Opatch conflict check 

Determine whether any currently installed one-off patches conflict with this patch 34416665 as follows:

Run OPatch Conflict Check

For Grid Infrastructure Home, as home user:

export ORACLE_HOME=/u01/app/19.3.0.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34419443

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34444834

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34428761

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34580338

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/33575402

Node 1:

Node 2:

Run the conflict check for the database home. 

As oracle user, run below steps.

export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34419443

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/34416665/34444834

Node 1

Node2

Run the system space check on both the nodes
Check if we have enough free space available in both GRID and DB homes for the patch to be applied. 

Create two files, one with Grid patch info and another one with DB patch info as shown below

For Grid home, create below file.

oracle@oraprim01 software]$ cat /tmp/patch_list_gihome.txt

/u01/software/34416665/34419443

/u01/software/34416665/34444834

/u01/software/34416665/34428761

/u01/software/34416665/34580338

/u01/software/34416665/33575402

[oracle@oraprim01 software]$

Run the below command to check the ststem space for GRID home.

For Database home, create below file

[oracle@oraprim01 software]$ cat /tmp/patch_list_dbhome.txt

/u01/software/34416665/34419443

/u01/software/34416665/34444834

[oracle@oraprim01 software]$

We need to run the same on the all the nodes of the clusters.

Check the One-off Patch Conflict Detection and Resolution

As ROOT user, run this step in all the nodes of the cluster. This will check conflicts for both the grid and database homes.

export ORACLE_HOME=/u01/app/19.3.0.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

 $ORACLE_HOME/OPatch/opatchauto apply /u01/software/34416665 -analyze

Patch Installation

As root user, apply the patch using 'opatchauto'

Apply the patch on all the nodes of the cluster.

Once the patch is applied in all the nodes, Check the inventor to see if the new patch is applied successfully and also check the DB registry in the database.

Output of the command, 'opatch lspatches' for the grid and DB homes.

Output of the dba_registry of the database.

In this post, we saw how to apply the latest Oracle RU to both Grid and database homes using 'opatchauto' .

Thanks
Sambaiah Sammeta