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
[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
[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
[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
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