RAC 19C PATCHING

RAC patch will be rolling patch. First stop all the services on node1 and apply the patch on node1. Once the node1 patch get completed then apply the patch on node2

winscp latest patch to /u01/patches and unzip and change opatch version on both GRID HOME and ORACLE HOME

1 2 3 4 5 6 7 8 9 10

[oracle@node1 ~]$ cd /u01/patches/ [oracle@node1 patches]$ [oracle@node1 patches]$ [oracle@node1 patches]$ ls -lrt total 2682072 drwxr-x---. 15 grid oinstall       4096 Jan  9  2022 OPatch drwxr-x---.  8 grid oinstall       4096 Jan 13  2022 33509923 -rw-rw-r--.  1 grid oinstall    1478442 Jan 20  2022 PatchSearch.xml -rw-r--r--.  1 grid oinstall  122883929 Aug  8 20:25 p6880880_122010_Linux-x86-64.zip -rw-r--r--.  1 grid oinstall 2622069290 Aug  8 20:28 p33509923_190000_Linux-x86-64.zip

Upgrade OPatch on both GRID HOME and ORACLE HOME

1 2	[grid@node1 patches]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old [oracle@node1 patches]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old

Check OPatch version after upgrade

1 2	[oracle@oraclelab1 patches]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch version OPatch Version: 12.2.0.1.29

Prechecks

Check Patch Conflict

1 2 3 4 5 6 7 8 9

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33515361   $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33529556   $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33534448   $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33239955   $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33575402

Stop clusterware services

1	$ORACLE_HOME/crs/install/rootcrs.sh -prepatch

Apply the patch on GRID HOME

1 2 3 4 5

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33515361 $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33529556 $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33534448 $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33239955 $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33575402

Apply the patch on ORACLE_HOME

1 2	$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33515361 $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33529556

Start the clusterware services on Node 1

1	$ORACLE_HOME/crs/install/rootcrs.sh -postpatch

Repeat the Same steps on Node 2.

Apply the Database Patch

Database patching manual 

 

Database Patching:

==================

1) Do database prechks

@?/rdbms/admin/utlprp.sql 16

2) Run the database post steps

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

[oracle@node1 OPatch]$ sqlplus / as sysdba   SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 01:27:07 2023 Version 19.14.0.0.0   Copyright (c) 1982, 2021, Oracle. All rights reserved.   Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.0.0.0   SQL> show pdbs;   CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ WRITE NO 3 PDBPRIM MOUNTED 4 PDBPRIM2 MOUNTED SQL> SQL> SQL> alter pluggable database all open instances=all;   Pluggable database altered.   exit   cd $ORACLE_HOME/OPatch nohup ./datapatch -verbose &

Recompile Invalid objects

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

[oracle@node1 rdbms]$ cd $ORACLE_HOME/rdbms/admin [oracle@node1 admin]$ [oracle@node1 admin]$ sqlplus / as sysdba   SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 01:34:28 2023 Version 19.14.0.0.0   Copyright (c) 1982, 2021, Oracle.  All rights reserved.     Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.0.0.0   SQL> @utlrp.sql

3) Verify the database post steps

1 2 3 4 5 6

set pagesize 1000; set linesize 1000; col STATUS for a10; col ACTION_TIME format a30; col DESCRIPTION format a55; select PATCH_ID,status,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;

Here on node2 auto patch command is used so database patch is done automatically    

AutoPatch in RAC

1 2 3

$ORACLE_HOME/OPatch/opatchauto apply /u02/patches/33509923 -oh $ORACLE_HOME   /u01/app/oracle/product/19C/dbhome/OPatch/opatchauto apply /u02/patches/33509923 -oh /u01/app/oracle/product/19C/dbhome