Apply RU 19.27 Patch on Oracle 19c RAC Environment: In this article we will explain how to apply RU 19.27 Patch on Oracle 19c RAC Environment using opatchauto Utility.
To apply RU 19.27 on Oracle 19c RAC, you need to ensure the OPatch utility is updated to version 12.2.0.1.45 or later. You'll also need to verify your current environment details, including the Oracle Database version, operating system, and cluster configuration. The process involves using the opatch utility to apply the patch to your Oracle 19c RAC environment.Steps to Apply RU 19.27 Patch on Oracle 19c RAC:
- Environment Details
- Download the patch from MOS (My Oracle Support)
- Unzip Patch file
- Upgrade OPatch Utility for RAC all nodes
- Now, Check Applied List of Patches from RAC all nodes
- Check INVALID Objects
- Check dba_registry & dba_registry_sqlpatch
- Run Analyze from Grid and Oracle Home on RAC all nodes
- Backup Grid Home/Oracle Home/Inventory on RAC all nodes
- Apply the Patch using opatchauto Utility
- Check & Verify Applied List of Patches from RAC all nodes
- Check & Verify from dba_registry & dba_registry_sqlpatch
- Lastly, Check & Verify INVALID objects
Environment Details:
Platform : Oracle Linux Server 8.10 (x86_64)
Real Application Cluster (RAC) : Yes
File system : Automatic Storage Management (ASM)
No of Nodes : 2 Node RAC setup
Hostnames : rac-node-1.localdomain , rac-node-2.localdomain
RAC Version : Oracle 19c RAC (19.22)
Database Version : Oracle 19c Database (19.22)
DB Name : ORCL
Grid Home : /u02/app/19c/grid
Grid Base : /u02/app/grid_base
Oracle Home : /u01/app/oracle/product/19c/dbhome_1
Oracle Base : /u01/app/oracle
Grid Patch Location : /u02/softwares/37641958
Database Patch Location : /u01/softwares/37641958
Central Inventory : /u02/app/oraInventoryDownload the patch from MOS (My Oracle Support):
Login to the MOS (My Oracle Support) and download the RU (19.27) 37641958 Patch zip file.

Unzip Patch file:
Unzip the downloaded patch file p37641958_190000_Linux-x86-64.zip on all RAC nodes. Ensure the following:
- Do not unzip the file using the root user.
- If both Oracle Database and Grid Infrastructure binaries are owned by the same OS user (e.g., oracle), unzip the patch file using that user.
- If the Oracle and Grid Infrastructure binaries are owned by different users (e.g., oracle for DB and grid for GI), unzip the patch file separately under each relevant user.
In our case, we are using different users – oracle for the database and grid for the Grid Infrastructure.
rac-node-1:
===============================
Unzip the Patch file using Grid User:
-----------------------------------------------
[grid@rac-node-1 ~]$ cd /u02/softwares/
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$ ls -ltrh p37641958_190000_Linux-x86-64.zip
-rwxrwxr-x 1 grid oinstall 3.7G May 13 13:06 p37641958_190000_Linux-x86-64.zip
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$ unzip p37641958_190000_Linux-x86-64.zip
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$
[grid@rac-node-1 softwares]$ ls -ltrh
total 7.5G
drwxr-x--- 8 grid oinstall 159 Apr 15 11:30 37641958
-rw-rw-r-- 1 grid oinstall 2.7M Apr 16 21:56 PatchSearch.xml
-rwxrwxr-x 1 grid oinstall 3.7G May 13 13:06 p37641958_190000_Linux-x86-64.zip
[grid@rac-node-1 softwares]$
Unzip the Patch file using Oracle User:
-----------------------------------------------
[oracle@rac-node-1 ~]$ cd /u01/softwares/
[oracle@rac-node-1 softwares]$
[oracle@rac-node-1 softwares]$ ls -ltrh p37641958_190000_Linux-x86-64.zip
-rwxrwxr-x 1 oracle oinstall 3.7G May 13 12:59 p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-1 softwares]$
[oracle@rac-node-1 softwares]$
[oracle@rac-node-1 softwares]$ unzip p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-1 softwares]$
[oracle@rac-node-1 softwares]$
[oracle@rac-node-1 softwares]$ ls -ltrh
total 3.8G
drwxr-x--- 8 oracle oinstall 159 Apr 15 11:30 37641958
-rw-rw-r-- 1 oracle oinstall 2.7M Apr 16 21:56 PatchSearch.xml
-rwxrwxr-x 1 oracle oinstall 3.7G May 13 12:59 p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-1 softwares]$
rac-node-2:
===============================
Unzip the Patch file using Grid User:
-----------------------------------------------
[grid@rac-node-2 ~]$ cd /u02/softwares/
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$ ls -ltrh p37641958_190000_Linux-x86-64.zip
-rwxrwxr-x 1 grid oinstall 3.7G May 13 13:06 p37641958_190000_Linux-x86-64.zip
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$ unzip p37641958_190000_Linux-x86-64.zip
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$
[grid@rac-node-2 softwares]$ ls -ltrh
total 7.5G
drwxr-x--- 8 grid oinstall 159 Apr 15 11:30 37641958
-rw-rw-r-- 1 grid oinstall 2.7M Apr 16 21:56 PatchSearch.xml
-rwxrwxr-x 1 grid oinstall 3.7G May 13 13:06 p37641958_190000_Linux-x86-64.zip
[grid@rac-node-2 softwares]$
Unzip the Patch file using Oracle User:
-----------------------------------------------
[oracle@rac-node-2 ~]$ cd /u01/softwares/
[oracle@rac-node-2 softwares]$
[oracle@rac-node-2 softwares]$ ls -ltrh p37641958_190000_Linux-x86-64.zip
-rwxrwxr-x 1 oracle oinstall 3.7G May 13 12:59 p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-2 softwares]$
[oracle@rac-node-2 softwares]$
[oracle@rac-node-2 softwares]$ unzip p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-2 softwares]$
[oracle@rac-node-2 softwares]$
[oracle@rac-node-2 softwares]$ ls -ltrh
total 3.8G
drwxr-x--- 8 oracle oinstall 159 Apr 15 11:30 37641958
-rw-rw-r-- 1 oracle oinstall 2.7M Apr 16 21:56 PatchSearch.xml
-rwxrwxr-x 1 oracle oinstall 3.7G May 13 12:59 p37641958_190000_Linux-x86-64.zip
[oracle@rac-node-2 softwares]$Upgrade OPatch Utility for RAC all nodes:
rac-node-1:
===============================
For Grid Home:
------------------------
[grid@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-1 OPatch]$
[grid@rac-node-1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[grid@rac-node-1 OPatch]$
[grid@rac-node-1 OPatch]$ su - root
Password:
[root@rac-node-1 ~]#
[root@rac-node-1 ~]# mv /u02/app/19c/grid/OPatch /u02/app/19c/grid/OPatch_bkp
[root@rac-node-1 ~]#
[root@rac-node-1 ~]# unzip -o /u01/softwares/p6880880_190000_Linux-x86-64.zip -d /u02/app/19c/grid
[root@rac-node-1 ~]#
[root@rac-node-1 ~]# cd /u02/app/19c/grid
[root@rac-node-1 grid]#
[root@rac-node-1 grid]# chown -R grid:oinstall OPatch
[root@rac-node-1 grid]#
[root@rac-node-1 grid]# logout
[grid@rac-node-1 OPatch]$
[grid@rac-node-1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
[grid@rac-node-1 OPatch]$
For Oracle Home:
------------------------
[oracle@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-1 OPatch]$
[oracle@rac-node-1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@rac-node-1 OPatch]$
[oracle@rac-node-1 OPatch]$ cd ..
[oracle@rac-node-1 dbhome_1]$
[oracle@rac-node-1 dbhome_1]$ mv /u01/app/oracle/product/19c/dbhome_1/OPatch /u01/app/oracle/product/19c/dbhome_1/OPatch_bkp
[oracle@rac-node-1 dbhome_1]$
[oracle@rac-node-1 dbhome_1]$ unzip -o /u01/softwares/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19c/dbhome_1
[oracle@rac-node-1 dbhome_1]$
[oracle@rac-node-1 dbhome_1]$ cd OPatch
[oracle@rac-node-1 OPatch]$
[oracle@rac-node-1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
[oracle@rac-node-1 OPatch]$
rac-node-2:
===============================
For Grid Home:
------------------------
[grid@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-2 OPatch]$
[grid@rac-node-2 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[grid@rac-node-2 OPatch]$
[grid@rac-node-2 OPatch]$ su - root
Password:
[root@rac-node-2 ~]#
[root@rac-node-2 ~]# mv /u02/app/19c/grid/OPatch /u02/app/19c/grid/OPatch_bkp
[root@rac-node-2 ~]#
[root@rac-node-2 ~]# unzip -o /u01/softwares/p6880880_190000_Linux-x86-64.zip -d /u02/app/19c/grid
[root@rac-node-2 ~]#
[root@rac-node-2 ~]# cd /u02/app/19c/grid
[root@rac-node-2 grid]#
[root@rac-node-2 grid]# chown -R grid:oinstall OPatch
[root@rac-node-2 grid]#
[root@rac-node-2 grid]# logout
[grid@rac-node-2 OPatch]$
[grid@rac-node-2 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
[grid@rac-node-2 OPatch]$
For Oracle Home:
------------------------
[oracle@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-2 OPatch]$
[oracle@rac-node-2 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@rac-node-2 OPatch]$
[oracle@rac-node-2 OPatch]$ cd ..
[oracle@rac-node-2 dbhome_1]$
[oracle@rac-node-2 dbhome_1]$ mv /u01/app/oracle/product/19c/dbhome_1/OPatch /u01/app/oracle/product/19c/dbhome_1/OPatch_bkp
[oracle@rac-node-2 dbhome_1]$
[oracle@rac-node-2 dbhome_1]$ unzip -o /u01/softwares/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19c/dbhome_1
[oracle@rac-node-2 dbhome_1]$
[oracle@rac-node-2 dbhome_1]$ cd OPatch
[oracle@rac-node-2 OPatch]$
[oracle@rac-node-2 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
[oracle@rac-node-2 OPatch]$Now, Check Applied List of Patches from RAC all nodes:
rac-node-1:
===============================
Check from Grid Home:
------------------------------
[grid@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-1 OPatch]$
[grid@rac-node-1 OPatch]$ ./opatch lspatches
35988503;ACFS Interim patch for 35988503
36115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@rac-node-1 OPatch]$
Check from Oracle Home:
------------------------------------
[oracle@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-1 OPatch]$
[oracle@rac-node-1 OPatch]$ ./opatch lspatches
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
OPatch succeeded.
[oracle@rac-node-1 OPatch]$
rac-node-2:
===============================
Check from Grid Home:
------------------------------
[grid@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-2 OPatch]$
[grid@rac-node-2 OPatch]$ ./opatch lspatches
35988503;ACFS Interim patch for 35988503
36115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@rac-node-2 OPatch]$
Check from Oracle Home:
------------------------------------
[oracle@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-2 OPatch]$
[oracle@rac-node-2 OPatch]$ ./opatch lspatches
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
OPatch succeeded.
[oracle@rac-node-2 OPatch]$Check INVALID Objects:
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL>
SQL>
SQL> set lines 400 pages 40000
SQL> col owner for a15
SQL> col object_name for a35
SQL> select owner, object_name, object_type, status from dba_objects where status='INVALID';
no rows selected
SQL>Check dba_registry & dba_registry_sqlpatch:
SQL> set lines 400 pages 400
SQL> col COMP_ID for a15
SQL> col COMP_NAME for a40
SQL> col VERSION for a20
SQL> col STATUS for a20
SQL> select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
--------------- ---------------------------------------- ---------- --------------------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID
RAC Oracle Real Application Clusters 19.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID
XML Oracle XDK 19.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID
APS OLAP Analytic Workspace 19.0.0.0.0 VALID
XDB Oracle XML Database 19.0.0.0.0 VALID
OWM Oracle Workspace Manager 19.0.0.0.0 VALID
CONTEXT Oracle Text 19.0.0.0.0 VALID
ORDIM Oracle Multimedia 19.0.0.0.0 VALID
SDO Spatial 19.0.0.0.0 VALID
XOQ Oracle OLAP API 19.0.0.0.0 VALID
OLS Oracle Label Security 19.0.0.0.0 VALID
DV Oracle Database Vault 19.0.0.0.0 VALID
15 rows selected.
SQL>
SQL>
SQL> set lines 500 pages 1000
SQL> set long 2000000
SQL> col action_time format a12
SQL> col action format a10
SQL> col comments format a30
SQL> col description format a60
SQL> col namespace format a20
SQL> col status format a10
SQL> select to_char(action_time, 'yyyy-mm-dd') as action_time, action, status, description, patch_id from sys.dba_registry_sqlpatch order by action_time;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
------------ ---------- ---------- ------------------------------------------------------------ ----------
2025-04-15 APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 29517242
2025-05-13 APPLY SUCCESS Database Release Update : 19.22.0.0.240116 (35943157) 35943157
SQL>Run Analyze from Grid and Oracle Home on RAC all nodes:
Please run opatchauto from other than ‘/root’ and ‘/’ directory.
rac-node-1:
===============================
Analyze from Grid Home:
------------------------------
[root@rac-node-1 ~]# cd /u02/softwares/37641958
[root@rac-node-1 37641958]#
[root@rac-node-1 37641958]# /u02/app/19c/grid/OPatch/opatchauto apply /u02/softwares/37641958 -oh /u02/app/19c/grid -analyze
OPatchauto session is initiated at Wed May 14 11:28:54 2025
System initialization log file is /u02/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2025-05-14_11-28-59AM.log.
Session log file is /u02/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2025-05-14_11-29-10AM.log
The id for this session is GRH3
Executing OPatch prereq operations to verify patch applicability on home /u02/app/19c/grid
Patch applicability verified successfully on home /u02/app/19c/grid
Executing patch validation checks on home /u02/app/19c/grid
Patch validation checks successfully completed on home /u02/app/19c/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:rac-node-1
CRS Home:/u02/app/19c/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u02/softwares/37641958/37654975
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-29-26AM_1.log
Patch: /u02/softwares/37641958/37643161
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-29-26AM_1.log
Patch: /u02/softwares/37641958/36758186
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-29-26AM_1.log
Patch: /u02/softwares/37641958/37762426
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-29-26AM_1.log
Patch: /u02/softwares/37641958/37642901
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-29-26AM_1.log
OPatchauto session completed at Wed May 14 11:30:48 2025
Time taken to complete the session 1 minute, 50 seconds
[root@rac-node-1 37641958]#
Analyze from Oracle Home:
---------------------------------
[root@rac-node-1 ~]# cd /u01/softwares/37641958
[root@rac-node-1 37641958]#
[root@rac-node-1 37641958]# /u01/app/oracle/product/19c/dbhome_1/OPatch/opatchauto apply /u01/softwares/37641958 -oh /u01/app/oracle/product/19c/dbhome_1 -analyze
OPatchauto session is initiated at Wed May 14 11:32:41 2025
System initialization log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-05-14_11-32-51AM.log.
Session log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-05-14_11-33-10AM.log
The id for this session is G69Z
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Executing patch validation checks on home /u01/app/oracle/product/19c/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19c/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:rac-node-1
RAC Home:/u01/app/oracle/product/19c/dbhome_1
Version:19.0.0.0.0
==Following patches were SKIPPED:
Patch: /u01/softwares/37641958/37643161
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/36758186
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/37762426
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/softwares/37641958/37654975
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-33-26AM_1.log
Patch: /u01/softwares/37641958/37642901
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-33-26AM_1.log
OPatchauto session completed at Wed May 14 11:34:59 2025
Time taken to complete the session 2 minutes, 8 seconds
[root@rac-node-1 37641958]#
rac-node-2:
===============================
Analyze from Grid Home:
------------------------------
[root@rac-node-2 ~]# cd /u02/softwares/37641958
[root@rac-node-2 37641958]#
[root@rac-node-2 37641958]# /u02/app/19c/grid/OPatch/opatchauto apply /u02/softwares/37641958 -oh /u02/app/19c/grid -analyze
OPatchauto session is initiated at Wed May 14 11:51:57 2025
System initialization log file is /u02/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2025-05-14_11-52-06AM.log.
Session log file is /u02/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2025-05-14_11-52-24AM.log
The id for this session is 9UMP
Executing OPatch prereq operations to verify patch applicability on home /u02/app/19c/grid
Patch applicability verified successfully on home /u02/app/19c/grid
Executing patch validation checks on home /u02/app/19c/grid
Patch validation checks successfully completed on home /u02/app/19c/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:rac-node-2
CRS Home:/u02/app/19c/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u02/softwares/37641958/37654975
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-52-44AM_1.log
Patch: /u02/softwares/37641958/37643161
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-52-44AM_1.log
Patch: /u02/softwares/37641958/36758186
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-52-44AM_1.log
Patch: /u02/softwares/37641958/37762426
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-52-44AM_1.log
Patch: /u02/softwares/37641958/37642901
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-52-44AM_1.log
OPatchauto session completed at Wed May 14 11:54:10 2025
Time taken to complete the session 2 minutes, 4 seconds
[root@rac-node-2 37641958]#
Analyze from Oracle Home:
---------------------------------
[root@rac-node-2 ~]# cd /u01/softwares/37641958
[root@rac-node-2 37641958]#
[root@rac-node-2 37641958]# /u01/app/oracle/product/19c/dbhome_1/OPatch/opatchauto apply /u01/softwares/37641958 -oh /u01/app/oracle/product/19c/dbhome_1 -analyze
OPatchauto session is initiated at Wed May 14 11:54:53 2025
System initialization log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-05-14_11-55-02AM.log.
Session log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-05-14_11-55-22AM.log
The id for this session is TF8F
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Executing patch validation checks on home /u01/app/oracle/product/19c/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19c/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:rac-node-2
RAC Home:/u01/app/oracle/product/19c/dbhome_1
Version:19.0.0.0.0
==Following patches were SKIPPED:
Patch: /u01/softwares/37641958/37643161
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/36758186
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/37762426
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/softwares/37641958/37654975
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-55-40AM_1.log
Patch: /u01/softwares/37641958/37642901
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_11-55-40AM_1.log
OPatchauto session completed at Wed May 14 11:57:26 2025
Time taken to complete the session 2 minutes, 25 seconds
[root@rac-node-2 37641958]#Backup Grid Home/Oracle Home/Inventory on RAC all nodes:
GRID_HOME Backup:
======================
cd /u02/app/19c
nohup tar -pczvf /u02/backup/grid_Backup.tar.gz grid &
ORACLE_HOME Backup:
======================
cd /u01/app/oracle/product/19c
nohup tar -pczvf /u02/backup/dbhome_1_Backup.tar dbhome_1 &
oraInventory Backup:
======================
cd /u02/app
nohup tar -pczvf /u02/backup/oraInventory_Backup.tar oraInventory &Apply the Patch using opatchauto Utility:
Apply the Patch on Grid Home and Oracle Home for all RAC nodes.
rac-node-1:
===============================
Apply on Grid Home:
------------------------------------------------------------------
[root@rac-node-1 ~]# cd /u02/softwares/37641958
[root@rac-node-1 37641958]#
[root@rac-node-1 37641958]# /u02/app/19c/grid/OPatch/opatchauto apply /u02/softwares/37641958 -oh /u02/app/19c/grid
OPatchauto session is initiated at Wed May 14 14:12:39 2025
System initialization log file is /u02/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2025-05-14_02-12-45PM.log.
Session log file is /u02/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2025-05-14_02-12-59PM.log
The id for this session is 38WM
Executing OPatch prereq operations to verify patch applicability on home /u02/app/19c/grid
Patch applicability verified successfully on home /u02/app/19c/grid
Executing patch validation checks on home /u02/app/19c/grid
Patch validation checks successfully completed on home /u02/app/19c/grid
Performing prepatch operations on CRS - bringing down CRS service on home /u02/app/19c/grid
Prepatch operation log file location: /u02/app/grid_base/crsdata/rac-node-1/crsconfig/crs_prepatch_apply_inplace_rac-node-1_2025-05-14_02-14-39PM.log
CRS service brought down successfully on home /u02/app/19c/grid
Start applying binary patch on home /u02/app/19c/grid
Binary patch applied successfully on home /u02/app/19c/grid
Running rootadd_rdbms.sh on home /u02/app/19c/grid
Successfully executed rootadd_rdbms.sh on home /u02/app/19c/grid
Performing postpatch operations on CRS - starting CRS service on home /u02/app/19c/grid
Postpatch operation log file location: /u02/app/grid_base/crsdata/rac-node-1/crsconfig/crs_postpatch_apply_inplace_rac-node-1_2025-05-14_02-26-37PM.log
CRS service started successfully on home /u02/app/19c/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac-node-1
CRS Home:/u02/app/19c/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u02/softwares/37641958/36758186
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-16-42PM_1.log
Patch: /u02/softwares/37641958/37642901
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-16-42PM_1.log
Patch: /u02/softwares/37641958/37643161
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-16-42PM_1.log
Patch: /u02/softwares/37641958/37654975
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-16-42PM_1.log
Patch: /u02/softwares/37641958/37762426
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-16-42PM_1.log
OPatchauto session completed at Wed May 14 14:31:44 2025
Time taken to complete the session 18 minutes, 59 seconds
[root@rac-node-1 37641958]#
Apply on Oracle Home:
------------------------------------------------------------------
[root@rac-node-1 ~]# cd /u01/softwares/37641958
[root@rac-node-1 37641958]#
[root@rac-node-1 37641958]# /u01/app/oracle/product/19c/dbhome_1/OPatch/opatchauto apply /u01/softwares/37641958 -oh /u01/app/oracle/product/19c/dbhome_1
OPatchauto session is initiated at Wed May 14 14:32:06 2025
System initialization log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-05-14_02-32-14PM.log.
Session log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-05-14_02-32-34PM.log
The id for this session is IYM8
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Executing patch validation checks on home /u01/app/oracle/product/19c/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19c/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19c/dbhome_1
Successfully prepared home /u01/app/oracle/product/19c/dbhome_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/19c/dbhome_1
Following database(s) and/or service(s) are stopped and will be restarted later during the session: prod
Database service successfully brought down on home /u01/app/oracle/product/19c/dbhome_1
Performing prepatch operation on home /u01/app/oracle/product/19c/dbhome_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19c/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19c/dbhome_1
Failed while applying binary patches on home /u01/app/oracle/product/19c/dbhome_1
Running rootadd_rdbms.sh on home /u01/app/oracle/product/19c/dbhome_1
Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19c/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19c/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19c/dbhome_1
Starting database service on home /u01/app/oracle/product/19c/dbhome_1
Database service successfully started on home /u01/app/oracle/product/19c/dbhome_1
Preparing home /u01/app/oracle/product/19c/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19c/dbhome_1
No SQL patch operations are required on local node for this home
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac-node-1
RAC Home:/u01/app/oracle/product/19c/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u01/softwares/37641958/37643161
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/36758186
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/37762426
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/softwares/37641958/37642901
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-49-32PM_1.log
Patch: /u01/softwares/37641958/37654975
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_14-49-32PM_1.log
OPatchauto session completed at Wed May 14 14:58:03 2025
Time taken to complete the session 8 minutes, 48 seconds
[root@rac-node-1 37641958]#
rac-node-2:
===============================
Apply on Grid Home:
------------------------------------------------------------------
[root@rac-node-2 ~]# cd /u02/softwares/37641958
[root@rac-node-2 37641958]#
[root@rac-node-2 37641958]# /u02/app/19c/grid/OPatch/opatchauto apply /u02/softwares/37641958 -oh /u02/app/19c/grid
OPatchauto session is initiated at Wed May 14 15:06:27 2025
System initialization log file is /u02/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2025-05-14_03-06-36PM.log.
Session log file is /u02/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2025-05-14_03-06-48PM.log
The id for this session is MTH9
Executing OPatch prereq operations to verify patch applicability on home /u02/app/19c/grid
Patch applicability verified successfully on home /u02/app/19c/grid
Executing patch validation checks on home /u02/app/19c/grid
Patch validation checks successfully completed on home /u02/app/19c/grid
Performing prepatch operations on CRS - bringing down CRS service on home /u02/app/19c/grid
Prepatch operation log file location: /u02/app/grid_base/crsdata/rac-node-2/crsconfig/crs_prepatch_apply_inplace_rac-node-2_2025-05-14_03-08-33PM.log
CRS service brought down successfully on home /u02/app/19c/grid
Start applying binary patch on home /u02/app/19c/grid
Binary patch applied successfully on home /u02/app/19c/grid
Running rootadd_rdbms.sh on home /u02/app/19c/grid
Successfully executed rootadd_rdbms.sh on home /u02/app/19c/grid
Performing postpatch operations on CRS - starting CRS service on home /u02/app/19c/grid
Postpatch operation log file location: /u02/app/grid_base/crsdata/rac-node-2/crsconfig/crs_postpatch_apply_inplace_rac-node-2_2025-05-14_03-19-51PM.log
CRS service started successfully on home /u02/app/19c/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac-node-2
CRS Home:/u02/app/19c/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u02/softwares/37641958/36758186
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-10-17PM_1.log
Patch: /u02/softwares/37641958/37642901
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-10-17PM_1.log
Patch: /u02/softwares/37641958/37643161
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-10-17PM_1.log
Patch: /u02/softwares/37641958/37654975
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-10-17PM_1.log
Patch: /u02/softwares/37641958/37762426
Log: /u02/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-10-17PM_1.log
OPatchauto session completed at Wed May 14 15:25:32 2025
Time taken to complete the session 18 minutes, 56 seconds
[root@rac-node-2 37641958]#
Apply on Oracle Home:
------------------------------------------------------------------
[root@rac-node-2 ~]# cd /u01/softwares/37641958
[root@rac-node-2 37641958]#
[root@rac-node-2 37641958]# /u01/app/oracle/product/19c/dbhome_1/OPatch/opatchauto apply /u01/softwares/37641958 -oh /u01/app/oracle/product/19c/dbhome_1
OPatchauto session is initiated at Wed May 14 15:26:16 2025
System initialization log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-05-14_03-26-32PM.log.
Session log file is /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-05-14_03-26-51PM.log
The id for this session is BVUE
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Executing patch validation checks on home /u01/app/oracle/product/19c/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19c/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19c/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19c/dbhome_1
Successfully prepared home /u01/app/oracle/product/19c/dbhome_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/19c/dbhome_1
Following database(s) and/or service(s) are stopped and will be restarted later during the session: awsavdf,prod
Database service successfully brought down on home /u01/app/oracle/product/19c/dbhome_1
Performing prepatch operation on home /u01/app/oracle/product/19c/dbhome_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19c/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19c/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/19c/dbhome_1
Running rootadd_rdbms.sh on home /u01/app/oracle/product/19c/dbhome_1
Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19c/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19c/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19c/dbhome_1
Starting database service on home /u01/app/oracle/product/19c/dbhome_1
Database service successfully started on home /u01/app/oracle/product/19c/dbhome_1
Preparing home /u01/app/oracle/product/19c/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19c/dbhome_1
SQL patch applied successfully on home /u01/app/oracle/product/19c/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac-node-2
RAC Home:/u01/app/oracle/product/19c/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u01/softwares/37641958/37643161
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/36758186
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/softwares/37641958/37762426
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/softwares/37641958/37642901
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-29-43PM_1.log
Patch: /u01/softwares/37641958/37654975
Log: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-05-14_15-29-43PM_1.log
OPatchauto session completed at Wed May 14 15:47:11 2025
Time taken to complete the session 20 minutes, 39 seconds
[root@rac-node-2 37641958]#Check & Verify Applied List of Patches from RAC all nodes:
rac-node-1:
===============================
Check from Grid Home:
-----------------------------------------------------------------------------
[grid@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-1 OPatch]$
[grid@rac-node-1 OPatch]$ ./opatch lspatches
37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426)
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
OPatch succeeded.
[grid@rac-node-1 OPatch]$
Check from Oracle Home:
-----------------------------------------------------------------------------
[oracle@rac-node-1 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-1 OPatch]$
[oracle@rac-node-1 OPatch]$ ./opatch lspatches
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
OPatch succeeded.
[oracle@rac-node-1 OPatch]$
rac-node-2:
===============================
Check from Grid Home:
-----------------------------------------------------------------------------
[grid@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[grid@rac-node-2 OPatch]$
[grid@rac-node-2 OPatch]$ ./opatch lspatches
37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426)
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
OPatch succeeded.
[grid@rac-node-2 OPatch]$
Check from Oracle Home:
-----------------------------------------------------------------------------
[oracle@rac-node-2 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rac-node-2 OPatch]$
[oracle@rac-node-2 OPatch]$ ./opatch lspatches
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
OPatch succeeded.
[oracle@rac-node-2 OPatch]$Check & Verify from dba_registry & dba_registry_sqlpatch:
SQL> set lines 400 pages 400
SQL> col COMP_ID for a15
SQL> col COMP_NAME for a40
SQL> col VERSION for a20
SQL> col STATUS for a20
SQL> select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
--------------- ---------------------------------------- -------------------- --------------------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID
RAC Oracle Real Application Clusters 19.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID
XML Oracle XDK 19.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID
APS OLAP Analytic Workspace 19.0.0.0.0 VALID
XDB Oracle XML Database 19.0.0.0.0 VALID
OWM Oracle Workspace Manager 19.0.0.0.0 VALID
CONTEXT Oracle Text 19.0.0.0.0 VALID
ORDIM Oracle Multimedia 19.0.0.0.0 VALID
SDO Spatial 19.0.0.0.0 VALID
XOQ Oracle OLAP API 19.0.0.0.0 VALID
OLS Oracle Label Security 19.0.0.0.0 VALID
DV Oracle Database Vault 19.0.0.0.0 VALID
15 rows selected.
SQL>
SQL> set lines 500 pages 1000
SQL> set long 2000000
SQL> col action_time format a12
SQL> col action format a10
SQL> col comments format a30
SQL> col description format a60
SQL> col namespace format a20
SQL> col status format a10
SQL> select to_char(action_time, 'yyyy-mm-dd') as action_time, action, status, description, patch_id from sys.dba_registry_sqlpatch order by action_time;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
------------ ---------- ---------- ------------------------------------------------------------ ----------
2025-04-15 APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 29517242
2025-05-13 APPLY SUCCESS Database Release Update : 19.22.0.0.240116 (35943157) 35943157
2025-05-14 APPLY SUCCESS Database Release Update : 19.27.0.0.250415 (37642901) 37642901
SQL>Lastly, Check & Verify INVALID objects:
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL>
SQL> set lines 400 pages 40000
SQL> col owner for a15
SQL> col object_name for a35
SQL> select owner, object_name, object_type, status from dba_objects where status='INVALID';
no rows selected
SQL>Now you have successfully applied RU 19.27 Patch on your Oracle 19c RAC environment.
I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com. Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You can write to mail me through my Email.
Email :- orakldba@gmail.com
LinkedIn :- https://linkedin.com/in/prasantakirtaniya
Twitter :- https://twitter.com/prasantadba
Facebook Page :- https://www.facebook.com/orakldba
Website :- https://orakldba.com
ACE Profile :- https://ace.oracle.com/apex/ace/profile/prasantakirtaniya
Oracle Community :- https://community.oracle.com/customerconnect/profile/discussions/prasantakirtaniya

very informative
Thanks! Harshit for your valueable comment!
Datapatch -verbose is not required…..? If not then how sql registery is updated
Hi Dba,
No, you do not need to run datapatch -verbose manually when you use opatchauto to apply a Release Update (RU) patch in an Oracle RAC environment.
Note:-
======
opatchauto is Oracle’s automation tool for RAC and GI patching. When you use opatchauto to apply a database RU, it:
1. Patches the Oracle Home on all nodes.
2. Runs post-patch steps automatically, including datapatch for all databases registered in CRS (Cluster Ready Services).
Regards,
Prasanta