How to Patch 19.26 on Oracle Restart 19c (GRID and ORACLE)

 

GI and database home are currently on 19.24

What to achieve:-

1) Patch to 19.26

2) Patch both the GI and Database home in one operation

List of the steps to follow during the activity :

1. Check the current version of Opatch Tool
2. Upgrade the Opatch utility if needed
3. Take the backup of GRID HOME and ORACLE_HOME
4. Apply "AUTO" patch using root for GRID HOME and ORACLE_HOME
5. Validate applied patches on GRID HOME and ORACLE_HOME patch in inventory
6. Execute Post-installation Steps (datapatch)
7. Verify the status of the patch applied from dba_registry_sqlpatch.
8. Verify INVALID objects

Note:- Before applying patch, we have to change the compatibility of rdbms for diskgroup as we faced issue with "datapatch" auto applying

[grid@gms04dbaora01t ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 5 08:09:40 2025
Version 19.23.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0

SQL>
SQL>
SQL>
SQL>
SQL>
SQL> SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,
substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;  2

DISKGROUP                      ASM_COMPAT   DB_COMPAT
------------------------------ ------------ ------------
ARCH_ORCL                  19.0.0.0.0   10.1.0.0.0
DATA_ORCL                  19.0.0.0.0   10.1.0.0.0

SQL>
SQL>
SQL> ALTER DISKGROUP DATA_ORCL SET ATTRIBUTE 'compatible.rdbms' = '19.0';

Diskgroup altered.

SQL>
SQL> ALTER DISKGROUP ARCH_ORCL SET ATTRIBUTE 'compatible.rdbms' = '19.0';

Diskgroup altered.

SQL>
SQL>
SQL> SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,
substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;  2

DISKGROUP                      ASM_COMPAT   DB_COMPAT
------------------------------ ------------ ------------
ARCH_ORCL                      19.0.0.0.0   19.0.0.0.0
DATA_ORCL                      19.0.0.0.0   19.0.0.0.0

Check the OPatch version for GRID and Oracle:-

1. Download p6880880_190000_Linux-x86-64.zip OPatch for GRID HOME and Oracle Home:-

2. Copy p6880880_190000_Linux-x86-64.zip to GRID_HOME as root user and ORACLE_HOME as Oracle users

Update the OPatch version for GRID_HOME:- 

[grid@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.42

OPatch succeeded.

[root@gms04dbaora01t grid_home]# mv OPatch OPatch_bkp
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]# pwd
/applications/oracle/g19.3.0/grid_home
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
root@gms04dbaora01t grid_home]# unzip p6880880_190000_Linux-x86-64.zip
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]# chown -R grid:oinstall OPatch
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#

[grid@gms04dbaora01t grid_home]$
[grid@gms04dbaora01t grid_home]$ cd OPatch
[grid@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.45

OPatch succeeded.

grid@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.42

OPatch succeeded.

[root@gms04dbaora01t grid_home]# mv OPatch OPatch_bkp
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]# pwd
/applications/oracle/g19.3.0/grid_home
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
root@gms04dbaora01t grid_home]# unzip p6880880_190000_Linux-x86-64.zip
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]# chown -R grid:oinstall OPatch
[root@gms04dbaora01t grid_home]#
[root@gms04dbaora01t grid_home]#

[grid@gms04dbaora01t grid_home]$
[grid@gms04dbaora01t grid_home]$ cd OPatch
[grid@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.45

OPatch succeeded.

Update the OPatch version for ORACLE_HOME:- 

[oracle@gms04dbaora01t ~]$ cd /applications/oracle/d19.3.0/oracle_home/OPatch
[oracle@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.41

OPatch succeeded.

[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$ mv OPatch OPatch_bkp_030225
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$ unzip p6880880_190000_Linux-x86-64.zip
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$
[oracle@gms04dbaora01t oracle_home]$

[oracle@gms04dbaora01t oracle_home]$ cd OPatch
[oracle@gms04dbaora01t OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.45

OPatch succeeded.

Determine whether any currently installed interim patches conflict with the patch being installed.

Downloaded 19.26 Patch and kept in /tmp/19.26_Grid - location 

[grid@gms04dbaora01t OPatch]$ cd /tmp/19.26_Grid/37257886/37268031
[grid@gms04dbaora01t 37268031]$
[grid@gms04dbaora01t 37268031]$
[grid@gms04dbaora01t 37268031]$
[grid@gms04dbaora01t 37268031]$ ls -lrt
[grid@gms04dbaora01t 37257886]$ ls -lrt
total 164
drwxrwxr-x 5 grid oinstall     62 Jan 20 14:03 37268031
drwxrwxr-x 5 grid oinstall     62 Jan 20 14:04 37266638
drwxrwxr-x 4 grid oinstall     48 Jan 20 14:05 37461387
drwxrwxr-x 5 grid oinstall     81 Jan 20 14:05 37260974
drwxrwxr-x 4 grid oinstall     48 Jan 20 14:05 36758186
-rwxrwxr-x 1 grid oinstall      0 Jan 20 14:08 README.txt
drwxrwxr-x 2 grid oinstall   4096 Jan 20 14:08 automation
-rwxrwxr-x 1 grid oinstall   5824 Jan 20 15:34 bundle.xml
-rwxrwxr-x 1 grid oinstall 152404 Jan 21 11:08 README.html
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ export PATH=$PATH:/applications/oracle/g19.3.0/grid_home/OPatch
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37268031
-bash: ./opatch: No such file or directory
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ cd /applications/oracle/g19.3.0/grid_home/OPatch
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37268031
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-13-31PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37268031
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-14-48PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37266638
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-15-05PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.





[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37461387
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-15-21PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.





[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37260974
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-15-38PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.




[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/36758186
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-02-04_17-16-06PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.





[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ ./opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/g19.3.0/grid_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/g19.3.0/grid_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatch/opatch2025-01-30_14-35-07PM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.


Check Conflict with ORACLE_HOME:-

[oracle@gms04dbaora01t ~]$ . oraenv
ORACLE_SID = [ORCL] ?
The Oracle base remains unchanged with value /applications/oracle/d19.3.0/oracle_base
[oracle@gms04dbaora01t ~]$
[oracle@gms04dbaora01t ~]$
[oracle@gms04dbaora01t ~]$ export PATH=$PATH:/applications/oracle/d19.3.0/oracle_home/OPatch
[oracle@gms04dbaora01t ~]$
[oracle@gms04dbaora01t ~]$
[oracle@gms04dbaora01t ~]$ cd /applications/oracle/d19.3.0/oracle_home/OPatch
[oracle@gms04dbaora01t OPatch]$
[oracle@gms04dbaora01t OPatch]$
[oracle@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37268031
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/d19.3.0/oracle_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/d19.3.0/oracle_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/d19.3.0/oracle_home/cfgtoollogs/opatch/opatch2025-02-04_17-17-00PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.





[oracle@gms04dbaora01t OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/19.26_Grid/37257886/37260974
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /applications/oracle/d19.3.0/oracle_home
Central Inventory : /applications/oracle/oraInventory
   from           : /applications/oracle/d19.3.0/oracle_home/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /applications/oracle/d19.3.0/oracle_home/cfgtoollogs/opatch/opatch2025-02-04_17-17-21PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Now apply the Patch using ROOT user and Patch will be applied to GRID_HOME and ORACLE_HOME automatically. 

Note:- No need to shutdown any services from our end.

[root@gms04dbaora01t OPatch]# opatchauto apply /tmp/19.26_Grid/37257886

OPatchauto session is initiated at Wed Feb  5 08:38:29 2025

System initialization log file is /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchautodb/systemconfig2025-02-05_08-38-33AM.log.

Session log file is /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/opatchauto2025-02-05_08-38-37AM.log
The id for this session is 68HD

Executing OPatch prereq operations to verify patch applicability on home /applications/oracle/d19.3.0/oracle_home
Patch applicability verified successfully on home /applications/oracle/d19.3.0/oracle_home


Executing patch validation checks on home /applications/oracle/d19.3.0/oracle_home
Patch validation checks successfully completed on home /applications/oracle/d19.3.0/oracle_home


Verifying SQL patch applicability on home /applications/oracle/d19.3.0/oracle_home
SQL patch applicability verified successfully on home /applications/oracle/d19.3.0/oracle_home


Executing OPatch prereq operations to verify patch applicability on home /applications/oracle/g19.3.0/grid_home
Patch applicability verified successfully on home /applications/oracle/g19.3.0/grid_home


Executing patch validation checks on home /applications/oracle/g19.3.0/grid_home
Patch validation checks successfully completed on home /applications/oracle/g19.3.0/grid_home


Preparing to bring down database service on home /applications/oracle/d19.3.0/oracle_home
Successfully prepared home /applications/oracle/d19.3.0/oracle_home to bring down database service


Bringing down database service on home /applications/oracle/d19.3.0/oracle_home
Following database has been stopped and will be restarted later during the session: r01esb01
Database service successfully brought down on home /applications/oracle/d19.3.0/oracle_home


Performing prepatch operations on CRS - bringing down CRS service on home /applications/oracle/g19.3.0/grid_home
Prepatch operation log file location: /applications/oracle/g19.3.0/grid_base/crsdata/gms04dbaora01t/crsconfig/hapatch_2025-02-05_08-42-06AM.log
CRS service brought down successfully on home /applications/oracle/g19.3.0/grid_home


Start applying binary patch on home /applications/oracle/d19.3.0/oracle_home
Binary patch applied successfully on home /applications/oracle/d19.3.0/oracle_home


Running rootadd_rdbms.sh on home /applications/oracle/d19.3.0/oracle_home
Successfully executed rootadd_rdbms.sh on home /applications/oracle/d19.3.0/oracle_home


Start applying binary patch on home /applications/oracle/g19.3.0/grid_home
Binary patch applied successfully on home /applications/oracle/g19.3.0/grid_home


Running rootadd_rdbms.sh on home /applications/oracle/g19.3.0/grid_home
Successfully executed rootadd_rdbms.sh on home /applications/oracle/g19.3.0/grid_home


Performing postpatch operations on CRS - starting CRS service on home /applications/oracle/g19.3.0/grid_home
Postpatch operation log file location: /applications/oracle/g19.3.0/grid_base/crsdata/gms04dbaora01t/crsconfig/hapatch_2025-02-05_08-57-30AM.log
CRS service started successfully on home /applications/oracle/g19.3.0/grid_home


Starting database service on home /applications/oracle/d19.3.0/oracle_home
Database service successfully started on home /applications/oracle/d19.3.0/oracle_home


Preparing home /applications/oracle/d19.3.0/oracle_home after database service restarted
No step execution required.........


Trying to apply SQL patch on home /applications/oracle/d19.3.0/oracle_home
SQL patch applied successfully on home /applications/oracle/d19.3.0/oracle_home

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:gms04dbaora01t
SIDB Home:/applications/oracle/d19.3.0/oracle_home
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /tmp/19.26_Grid/37257886/37266638
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /tmp/19.26_Grid/37257886/36758186
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /tmp/19.26_Grid/37257886/37461387
Reason: This patch is not applicable to this specified target type - "oracle_database"


==Following patches were SUCCESSFULLY applied:

Patch: /tmp/19.26_Grid/37257886/37260974
Log: /applications/oracle/d19.3.0/oracle_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-43-00AM_1.log

Patch: /tmp/19.26_Grid/37257886/37268031
Log: /applications/oracle/d19.3.0/oracle_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-43-00AM_1.log


Host:gms04dbaora01t
SIHA Home:/applications/oracle/g19.3.0/grid_home
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /tmp/19.26_Grid/37257886/36758186
Log: /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-49-43AM_1.log

Patch: /tmp/19.26_Grid/37257886/37260974
Log: /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-49-43AM_1.log

Patch: /tmp/19.26_Grid/37257886/37266638
Log: /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-49-43AM_1.log

Patch: /tmp/19.26_Grid/37257886/37268031
Log: /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-49-43AM_1.log

Patch: /tmp/19.26_Grid/37257886/37461387
Log: /applications/oracle/g19.3.0/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2025-02-05_08-49-43AM_1.log



OPatchauto session completed at Wed Feb  5 09:01:41 2025
Time taken to complete the session 23 minutes, 8 seconds

Crosscheck the Applied patch details.

[root@gms04dbaora01t OPatch]# su - grid
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base has been set to /applications/oracle/g19.3.0/grid_base
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ export PATH=$PATH:/applications/oracle/g19.3.0/grid_home/OPatch
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$
[grid@gms04dbaora01t ~]$ cd /applications/oracle/g19.3.0/grid_home/OPatch
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ opatch lspatches
37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)
37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638)
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)

OPatch succeeded.

Post-check for checking GRID Version :-

[grid@gms04dbaora01t OPatch]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [117906255] and the complete list of patches [36758186 37260974 37266638 37268031 37461387 ] have been applied on the local node. The release patch string is [19.26.0.0.0].
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@gms04dbaora01t OPatch]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$
[grid@gms04dbaora01t OPatch]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node gms04dbaora01t is [117906255].

Note:- Apply SQL changes (datapatch)

When we applied 19.16 patch SQL changes automatically reflected/update by autopatch only so we don't need to run datapatch -verbose  explicitly 

[oracle@gms04dbaora01t bin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 5 09:06:00 2025
Version 19.26.0.0.0

Copyright (c) 1982, 2024, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.26.0.0.0

SQL> 
SET LINESIZE 400
SET PAGESIZE 100
COLUMN action_time FORMAT A20
COLUMN action FORMAT A10
COLUMN status FORMAT A10
COLUMN description FORMAT A85
SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
action,
status,
description,
patch_id
FROM   sys.dba_registry_sqlpatch
ORDER by action_time; 

																								    
ACTION_TIME          ACTION     STATUS     DESCRIPTION                                                PATCH_ID
-------------------- ---------- ---------- -------------------------------------------------------- ----------
05-FEB-2025 09:01:10 APPLY      SUCCESS    Database Release Update : 19.26.0.0.250121 (37260974)      37260974
19-JUN-2024 13:28:25 APPLY      SUCCESS    Database Release Update : 19.23.0.0.240416 (36233263)      36233263

[oracle@gms04dbaora01t OPatch]$ ./opatch lspatches
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)
37260974;Database Release Update : 19.26.0.0.250121 (37260974)