Apply RU 19.27 Patch on Oracle 19c RAC Environment

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:

  1. Environment Details
  2. Download the patch from MOS (My Oracle Support)
  3. Unzip Patch file
  4. Upgrade OPatch Utility for RAC all nodes
  5. Now, Check Applied List of Patches from RAC all nodes
  6. Check INVALID Objects
  7. Check dba_registry & dba_registry_sqlpatch
  8. Run Analyze from Grid and Oracle Home on RAC all nodes
  9. Backup Grid Home/Oracle Home/Inventory on RAC all nodes
  10. Apply the Patch using opatchauto Utility
  11. Check & Verify Applied List of Patches from RAC all nodes
  12. Check & Verify from dba_registry & dba_registry_sqlpatch
  13. 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/oraInventory

Download the patch from MOS (My Oracle Support):

Login to the MOS (My Oracle Support) and download the RU (19.27) 37641958 Patch zip file.

Download Oracle 19.27 RU Patch for RAC

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

4 thoughts on “Apply RU 19.27 Patch on Oracle 19c RAC Environment”

    • 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

      Reply

Leave a Comment