Environment: Current Database: Oracle Database 19.14 Operating System : AIX 7.3 64 Bit Type: Grid Infrastructure for Standalone Oracle Restart Database Patch to be applied: 1)Patch 36916690: GI RELEASE UPDATE 19.25.0.0.0 2)Patch 36912597: Database Release Update 19.25.0.0.241015 3)Patch 36878697: OJVM RELEASE UPDATE 19.25.0.0.0 4)OPatch 12.2.0.1.46 Note: Oracle Standalone database on Grid Infrastrucure without RAC is also called as Oracle Restart Database. High Level Steps to apply patch on Oracle Restart Database Step by Step: Step 1 : Download Patch and Opatch setups from Oracle Support Site (Oracle License Required). Step 2 : Perform pre-requisites before applying patch for any conflict check. Step 3: If no conflict found, then ask client for database downtime for applying patch. Step 4: Once you get the downtime for applying a patch, then stop application, stop DB services and apply patch. Step 5: Execute Datapatch -Verbose command as post patching steps. Step 6: Start DB services and start application. Here, are the detail plan of action for applying a patch on Oracle Restart Database.... Step 1: Download Patch and Opatch setups from Oracle Support Site (Oracle License Required). Go to Google and type "Oracle Critical Patch Advisory Oct 2024". Click on first link.   Below screen will be appeared. CTRL+F and search the keyword "Database" on this screen. Locate the line "Oracle Database Server, versions 19.3-19.24,21.3-21.15,23.4-23.5". Please note that don't click on this line, instaed click on Right Side keyword "Database".  |
You will be asked for Oracle Support Credentials. Login to Oracle Support Site and then below screen will be appeared. Search "Oracle Database 19". You will find several patches on screen. Here, we will download below patches.
Note: Please note that "Database Release Update 19.25.0.0.241015" patch is already part of "GI RELEASE UPDATE 19.25.0.0.0" and hence you don't need to download it separately.
1) Patch 36916690: GI RELEASE UPDATE 19.25.0.0.0
2) Patch 36912597: Database Release Update 19.25.0.0.241015
3) Patch 36878697: OJVM RELEASE UPDATE 19.25.0.0.0
4) OPatch 12.2.0.1.46
Click on each patch to be dowbloaded. Below screen will be appeared. Locate proper Operating System. Here, the Operating System is "IBM AIX on POWER Systems (64-bit)". Click on "Download" button to download the patch.
Once you download the patch, you can also check the respective ReadMe file for more details about patch.
Look at the below screen and locate "Table 1-2 Patch Numbers Installed as Part of this Bundle Patch"
Note: Please note that you have to apply below all patches to both GRID as well as RDBMS homes if the environment is Oracle RAC. If the environment is non-RAC then you don't have to apply all patches on GRID and RDBMS, instead you have to apply only last four patches (36917416,36917397,36940756,36758186) to GRID and first two patches (36912597,36917416) for RDBMS home.
1) 36912597 - Database Release Update 19.25.0.0.241015 - Only Oracle home for non-Oracle RAC setup. Both Oracle home and Grid home for Oracle RAC setup.
2) 36917416 - OCW Release Update 19.25.0.0.241015 - Both Oracle home and Grid home.
3) 36917397 - ACFS Release Update 19.25.0.0.241015 - Only Grid home.
4) 36940756 - Tomcat Release Update 19.0.0.0.0 - Only Grid home.
5) 36758186 - DBWLM Release Update 19.0.0.0.0 - Only Grid home.
Additionally, before applying a patch, you have to replace a minimum required OPatch Version as well. For downloading required OPatch version, refer below screen "2.1.1.1 OPatch Utility Information".
Select proper operating system and DB version and click on "Download".
Similarly, you can download other patches as well.
GRID HOME Patching:Step 2: Once you download all the required patches, you have to transfer these patches to the target DB server. By root user , change the permissions and ownership of patch setup files. Note: Please note that though you give 777 permissions to patch setup files, Oracle will not allow you to patch to binaries until you change proper ownership.i.e. grid:oinstall for GRID_HOME and oracle:oinstall for RDBMS_HOME. root@testdb: >id uid=0(root) gid=0(system) groups=2(bin),3(sys),7(security),8(cron),10(audit),11(lp) root@testdb:/backup> chown -R grid:oinstall GRID root@testdb:/backup> chmod -R 775 GRID root@testdb:/backup/GRID/19.25_patches >ls -ltr -rwxrwxr-x 1 grid oinstall 174269905 Jun 23 11:29 p6880880_190000_AIX64-5L.zip -rwxrwxr-x 1 grid oinstall 2991134531 Jun 23 11:29 p36916690_190000_AIX64-5L.zip By grid user , unzip the patch setup files. grid@testdb:/u01/app/grid/19.0.0/grid >cd /backup/GRID/19.25_patches/ grid@testdb:/backup/GRID/19.25_patches >unzip p36916690_190000_AIX64-5L.zip grid@testdb:/backup/GRID/19.25_patches >ls -ltr drwxr-x--- 8 grid oinstall 4096 Oct 25 2024 36916690 -rw-rw-r-- 1 grid oinstall 2442860 Nov 01 2024 PatchSearch.xml -rwxrwxr-x 1 grid oinstall 174269905 Jun 23 11:29 p6880880_190000_AIX64-5L.zip -rwxrwxr-x 1 grid oinstall 2991134531 Jun 23 11:29 p36916690_190000_AIX64-5L.zip Step 3: Now replace the existing OPatch directory by new downloaded OPatch setup file. Note: Please note that you won't be able to copy/move files from existing GRID_HOME directory as it is owned by root user. For replacing OPatch directory either you have to unzip OPatch in separate ditectory, give required ownership and permissions and then copy to GRID_HOME. But you have another easy option which is required before applying a patch i.e. unlock GRID_HOME binaries. This will change the GRID_HOME directory so that you can copy/move activities and start applying patch otherwise, it won't allow you to apply patch. By root user, execute below commands to unlock GRID_HOME binaries. root@testdb:/backup/GRID/19.25_patches >cd /u01/app/grid/19.0.0/grid/crs/install/u01/app/grid/19.0.0/grid/crs/install root@testdb:/u01/app/grid/19.0.0/grid/crs/install >ls -ltr *root*.sh -rwxr-x--- 1 grid oinstall 8051 Jun 19 17:20 rootcrs.sh -rwxr-x--- 1 grid oinstall 3931 Jun 19 17:20 roothas.sh root@testdb:/u01/app/grid/19.0.0/grid/crs/install >./roothas.sh -unlock Using configuration parameter file: /u01/app/grid/19.0.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/testdb/crsconfig/haunlock__2025-06-23_11-39-43AM.log 2025/06/23 11:40:09 CLSRSC-347: Successfully unlock /u01/app/grid/19.0.0/grid root@testdb:/u01/app/grid/19.0.0/grid/crs/install >ps -ef | grep pmon root 17302006 29950330 0 11:40:15 pts/0 0:00 grep pmon By grid user, replace OPatch directory under GRID_HOME directory. grid@testdb:/home/grid >cd /u01/app/grid/19.0.0/grid/u01/app/grid/19.0.0/grid grid@testdb:/u01/app/grid/19.0.0/grid >ls -ld OPatch drwxr-x--- 15 grid oinstall 4096 Dec 23 2024 OPatch grid@testdb:/u01/app/grid/19.0.0/grid >mv OPatch OPatch_old1 grid@testdb:/backup/GRID/19.25_patches >cp p6880880_190000_AIX64-5L.zipp6880880_190000_AIX64-5L.zip /u01/app/grid/19.0.0/grid/u01/app/grid/19.0.0/grid grid@testdb:/u01/app/grid/19.0.0/grid >ls -ltr p6880880_190000_AIX64-5L.zip -rwxr-xr-x 1 grid oinstall 174269905 Jun 23 11:41 p6880880_190000_AIX64-5L.zip grid@testdb:/u01/app/grid/19.0.0/grid >unzip p6880880_190000_AIX64-5L.zipp6880880_190000_AIX64-5L.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ inflating: OPatch/oracle_common/modules/com.oracle.glcm.common-logging_1.6.5.0.jar inflating: OPatch/oracle_common/modules/common-logging-config.jar inflating: OPatch/opatch_env.sh inflating: OPatch/operr inflating: OPatch/README.txt ..... inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml creating: OPatch/opatchprereqs/opatch/ inflating: OPatch/opatchprereqs/opatch/rulemap.xml inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml grid@testdb:/u01/app/grid/19.0.0/grid >ls -ld OPatch drwxr-x--- 15 grid oinstall 4096 Apr 06 15:03 OPatch grid@testdb:/u01/app/grid/19.0.0/grid >cd OPatch grid@testdb:/u01/app/grid/19.0.0/grid/OPatch >cat version.txt OPATCH_VERSION:12.2.0.1.46 Step 4: Now check patch conflict for each patch under the main GI Patch one by one. grid@JBHOOEMDB:/backup/GRID/19.25_patches/36916690 >ls -ltr drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36912597 -rw-r--r-- 1 grid oinstall 0 Oct 25 2024 README.txt drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36940756 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917416 drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36758186 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917397 drwxr-x--- 2 grid oinstall 4096 Oct 25 2024 automation -rw-rw-r-- 1 grid oinstall 5824 Oct 25 2024 bundle.xml -rw-r--r-- 1 grid oinstall 134032 Oct 28 2024 README.html grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36912597 grid@testdb:/backup/GRID/19.25_patches/36916690/36912597 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-43-48AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36912597 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 3694075636940756 grid@testdb:/backup/GRID/19.25_patches/36916690/36940756 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-44-19AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36940756 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36917416 grid@testdb:/backup/GRID/19.25_patches/36916690/36917416 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-44-38AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36917416 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36758186 grid@testdb:/backup/GRID/19.25_patches/36916690/36758186 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-44-54AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36758186 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36917397 grid@testdb:/backup/GRID/19.25_patches/36916690/36917397 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-45-09AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. Step 5: Now apply all patches one by one. Please note that you can also apply all patches in single command using napply. grid@testdb:/home/grid >env | grep ORA ORACLE_HOME=/u01/app/grid/19.0.0/grid ORACLE_SID=+ASM export PATH=$ORACLE_HOME/OPatch:$PATH grid@testdb:/backup/GRID/19.25_patches/36916690/36912597 >opatch apply Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-47-11AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36912597 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/grid/19.0.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '36912597' to OH '/u01/app/grid/19.0.0/grid' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.rdbms.rat, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.rdbms.dm, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.precomp.common, 19.0.0.0.0 ] , [ oracle.precomp.lang, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.201.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.rdbms.util, 19.0.0.0.0... Patching component oracle.rdbms.rsf, 19.0.0.0.0... Patching component oracle.assistants.acf, 19.0.0.0.0... Patching component oracle.assistants.asm, 19.0.0.0.0... Patching component oracle.assistants.deconfig, 19.0.0.0.0... Patching component oracle.assistants.server, 19.0.0.0.0... Patching component oracle.blaslapack, 19.0.0.0.0... Patching component oracle.buildtools.rsf, 19.0.0.0.0... Patching component oracle.dbjava.ic, 19.0.0.0.0... Patching component oracle.dbjava.jdbc, 19.0.0.0.0... Patching component oracle.dbjava.ucp, 19.0.0.0.0... Patching component oracle.duma, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... Patching component oracle.ldap.owm, 19.0.0.0.0... Patching component oracle.ldap.rsf, 19.0.0.0.0... Patching component oracle.ldap.security.osdt, 19.0.0.0.0... Patching component oracle.network.rsf, 19.0.0.0.0... Patching component oracle.ons, 19.0.0.0.0... Patching component oracle.ons.ic, 19.0.0.0.0... Patching component oracle.oracore.rsf, 19.0.0.0.0... Patching component oracle.perlint, 5.28.1.0.0... Patching component oracle.precomp.rsf, 19.0.0.0.0... Patching component oracle.rdbms.crs, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms.deconfig, 19.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0... Patching component oracle.rhp.db, 19.0.0.0.0... Patching component oracle.rsf, 19.0.0.0.0... Patching component oracle.sdo.locator.jrf, 19.0.0.0.0... Patching component oracle.sqlplus, 19.0.0.0.0... Patching component oracle.sqlplus.ic, 19.0.0.0.0... Patching component oracle.tfa, 19.0.0.0.0... Patching component oracle.wwg.plsql, 19.0.0.0.0... Patching component oracle.xdk.rsf, 19.0.0.0.0... Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.ovm, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0... Patching component oracle.ldap.rsf.ic, 19.0.0.0.0... Patching component oracle.ldap.client, 19.0.0.0.0... Patching component oracle.install.deinstalltool, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.dbtoolslistener, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.ldap.ssl, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 19.0.0.0.0... Patching component oracle.network.listener, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.network.aso, 19.0.0.0.0... Patching component oracle.rdbms.locator, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.jdk, 1.8.0.5.201... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeout64 ld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeout64 ld: 0711-224 WARNING: Duplicate symbol: .bcopy_wrapper ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait64 ld: 0711-224 WARNING: Duplicate symbol: aio_nwait64 ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. ld: 0711-783 WARNING: TOC overflow. TOC size: 337192 Maximum size: 65536 Extra instructions are being generated for each reference to a TOC symbol if the symbol is in the TOC overflow area. OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .bcopy_wrapper ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .bcopy_wrapper ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. ld: 0711-783 WARNING: TOC overflow. TOC size: 88592 Maximum size: 65536 Extra instructions are being generated for each reference to a TOC symbol if the symbol is in the TOC overflow area. ....... Patch 36912597 successfully applied. Sub-set patch [33806138] has become inactive due to the application of a super-set patch [36912597]. Please refer to Doc ID 2161861.1 for any possible further required actions. OPatch Session completed with warnings. Log file location: /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-47-11AM_1.log OPatch completed with warnings. Note: Please note that the above warning messages are compiler warnings messages observed for AIX platform and can be ignored. grid@testdb:/backup/GRID/19.25_patches/36916690/36912597 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >ls -ltr drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36912597 -rw-r--r-- 1 grid oinstall 0 Oct 25 2024 README.txt drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36940756 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917416 drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36758186 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917397 drwxr-x--- 2 grid oinstall 4096 Oct 25 2024 automation -rw-rw-r-- 1 grid oinstall 5824 Oct 25 2024 bundle.xml -rw-r--r-- 1 grid oinstall 134032 Oct 28 2024 README.html grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36940756 grid@testdb:/backup/GRID/19.25_patches/36916690/36940756 >opatch apply Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-52-51AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36940756 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/grid/19.0.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '36940756' to OH '/u01/app/grid/19.0.0/grid' Patching component oracle.tomcat.crs, 19.0.0.0.0... Patch 36940756 successfully applied. Sub-set patch [33911149] has become inactive due to the application of a super-set patch [36940756]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-52-51AM_1.log OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36940756 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >ls -ltr drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36912597 -rw-r--r-- 1 grid oinstall 0 Oct 25 2024 README.txt drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36940756 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917416 drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36758186 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917397 drwxr-x--- 2 grid oinstall 4096 Oct 25 2024 automation -rw-rw-r-- 1 grid oinstall 5824 Oct 25 2024 bundle.xml -rw-r--r-- 1 grid oinstall 134032 Oct 28 2024 README.html grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36917416 grid@testdb:/backup/GRID/19.25_patches/36916690/36917416 >opatch apply -s silent Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-54-30AM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-55-27AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36917416 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/grid/19.0.0/grid') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36917416' to OH '/u01/app/grid/19.0.0/grid' ApplySession: Optional component(s) [ oracle.has.db.cvu, 19.0.0.0.0 ] , [ oracle.has.deconfig, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.has.db, 19.0.0.0.0... Patching component oracle.has.common.cvu, 19.0.0.0.0... Patching component oracle.xag, 19.0.0.0.0... Patching component oracle.has.common, 19.0.0.0.0... Patching component oracle.rhp.crs, 19.0.0.0.0... Patching component oracle.has.cvu, 19.0.0.0.0... Patching component oracle.rhp.common, 19.0.0.0.0... Patching component oracle.has.crs, 19.0.0.0.0... Patching component oracle.has.crs.cvu, 19.0.0.0.0... Patching component oracle.has.rsf, 19.0.0.0.0... Patching component oracle.rhp.db, 19.0.0.0.0... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .vsn_getVersion ld: 0711-224 WARNING: Duplicate symbol: vsn_getVersion ld: 0711-224 WARNING: Duplicate symbol: .sleprom ld: 0711-224 WARNING: Duplicate symbol: .slsprom ld: 0711-224 WARNING: Duplicate symbol: .pipe ld: 0711-224 WARNING: Duplicate symbol: pipe ld: 0711-224 WARNING: Duplicate symbol: .close ld: 0711-224 WARNING: Duplicate symbol: close ld: 0711-224 WARNING: Duplicate symbol: ss_dba_grp ld: 0711-224 WARNING: Duplicate symbol: .readlink ld: 0711-224 WARNING: Duplicate symbol: readlink ld: 0711-224 WARNING: Duplicate symbol: .slosFillErr ld: 0711-224 WARNING: Duplicate symbol: .slosDep2Mesg ld: 0711-224 WARNING: Duplicate symbol: .slosOtherInfo ld: 0711-224 WARNING: Duplicate symbol: .lstprintf ld: 0711-224 WARNING: Duplicate symbol: .lstlo ld: 0711-224 WARNING: Duplicate symbol: .lstss ld: 0711-224 WARNING: Duplicate symbol: .sltrusleep ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. Patch 36917416 successfully applied. Sub-set patch [33897261] has become inactive due to the application of a super-set patch [36917416]. Please refer to Doc ID 2161861.1 for any possible further required actions. OPatch Session completed with warnings. Log file location: /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_11-55-27AM_1.log OPatch completed with warnings. grid@testdb:/backup/GRID/19.25_patches/36916690/36917416 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >ls -ltr drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36912597 -rw-r--r-- 1 grid oinstall 0 Oct 25 2024 README.txt drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36940756 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917416 drwxr-x--- 4 grid oinstall 256 Oct 25 2024 36758186 drwxr-x--- 5 grid oinstall 256 Oct 25 2024 36917397 drwxr-x--- 2 grid oinstall 4096 Oct 25 2024 automation -rw-rw-r-- 1 grid oinstall 5824 Oct 25 2024 bundle.xml -rw-r--r-- 1 grid oinstall 134032 Oct 28 2024 README.html grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36758186 grid@testdb:/backup/GRID/19.25_patches/36916690/36758186 >opatch apply -silent Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_12-00-30PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36758186 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/grid/19.0.0/grid') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36758186' to OH '/u01/app/grid/19.0.0/grid' Patching component oracle.wlm.dbwlm, 19.0.0.0.0... Patch 36758186 successfully applied. Sub-set patch [33575402] has become inactive due to the application of a super-set patch [36758186]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_12-00-30PM_1.log OPatch succeeded. grid@testdb:/backup/GRID/19.25_patches/36916690/36758186 >cd .. grid@testdb:/backup/GRID/19.25_patches/36916690 >cd 36917397 grid@testdb:/backup/GRID/19.25_patches/36916690/36917397 >opatch apply -silent Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/grid/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/grid/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.46 OUI version : 12.2.0.7.0 Log file location : /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_12-01-53PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36917397 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/grid/19.0.0/grid') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36917397' to OH '/u01/app/grid/19.0.0/grid' Patching component oracle.usm, 19.0.0.0.0... Patch 36917397 successfully applied. Sub-set patch [33534448] has become inactive due to the application of a super-set patch [36917397]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/grid/19.0.0/grid/cfgtoollogs/opatch/opatch2025-06-23_12-01-53PM_1.log OPatch succeeded. Now after all patches, you can confirm the applied patches by "opatch lspatches" command. grid@testdb:/home/grid >opatch lspatches 36917397;ACFS RELEASE UPDATE 19.25.0.0.0 (36917397) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) 36917416;OCW RELEASE UPDATE 19.25.0.0.0 (36917416) 36940756;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36940756) 36912597;Database Release Update : 19.25.0.0.241015 (36912597) OPatch succeeded. Step 6: Now login as a root user and execute below commands to lock GRID_HOME binaries. root@testdb:/u01/app/grid/19.0.0/grid/crs/install >ls -ltr *root*.sh -rwxr-x--- 1 grid oinstall 8051 Jun 19 17:20 rootcrs.sh -rwxr-x--- 1 grid oinstall 3931 Jun 19 17:20 roothas.sh root@testdb:/u01/app/grid/19.0.0/grid/crs/install >./roothas.sh -lock Using configuration parameter file: /u01/app/grid/19.0.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/testdb/crsconfig/halock__2025-06-23_12-04-35AM.log 2025/06/23 12:04:36 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab' grid@testdb:/home/grid >ps -ef | grep pmon grid 6160860 22872420 0 12:05:08 pts/0 0:00 grep pmon grid@testdb:/home/grid >ps -ef | grep d.bin grid 25821454 22872420 0 12:05:12 pts/0 0:00 grep d.bin You can see that the above command has not started HAS because there are errors while starting HAS. Let's start HAS manually and see the errors. grid@testdb:/home/grid >./crsctl start has CRS-6706: Oracle Clusterware Release patch level ('1211422631') does not match Software patch level ('2018016837'). Oracle Clusterware cannot be started. CRS-4000: Command Start failed, or completed with errors. To fix the above error, execute below command by root user: root@testdb:/u01/app/grid/19.0.0/grid/bin >./clscfg -localpatch clscfg: EXISTING configuration version 0 detected. Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. Now try to start HAS service. You can see now DB and ASM are started successfully. grid@testdb:/home/grid >crsctl start has CRS-4123: Oracle High Availability Services has been started. grid@testdb:/home/grid >ps -ef | grep pmon grid 25821606 1 0 12:11:59 - 0:00 asm_pmon_+ASM grid 29294998 22872442 0 12:12:26 pts/0 0:00 grep pmon grid 33358106 1 0 12:12:22 - 0:00 ora_pmon_oemdb Login as oracle user and check the DB status: root@testdb:/u01/app/grid/19.0.0/grid/bin >su - oracle oracle@testdb:/home/oracle >sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 23 12:14:29 2025 Version 19.14.1.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.1.0.0 SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- OEMDB READ WRITE RDBMS HOME Patching:Step 1: Now it's time to appy patches on RDBMS Home. Let's stop the database and associated listener services. Here, no need to stop GRID HOME services since we are applying patches to only RDBMS home now. oracle@testdb:/home/oracle >sqlplus / as sysdba SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- OEMDB READ WRITE SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Here, for RDBMS Home, we have to apply below three patches. 36878697;OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697) 36917416;OCW RELEASE UPDATE 19.25.0.0.0 (36917416) 36912597;Database Release Update : 19.25.0.0.241015 (36912597) Step 2: Let's transfer above patches and opatch setup to apply RDBMS patches. Let's unzip one by one along with OPatch version. oracle@testdb:>cd /u01/app/oracle/product/19.0.0/dbhome_1 oracle@testdb:/u01/app/oracle/product/19.0.0/dbhome_1 >mv OPatch OPatch_old oracle@testdb:/u01/app/oracle/product/19.0.0/dbhome_1 >unzip p6880880_190000_AIX64-5L.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ inflating: OPatch/oracle_common/modules/com.oracle.glcm.common-logging_1.6.5.0.jar inflating: OPatch/oracle_common/modules/common-logging-config.jar inflating: OPatch/opatch_env.sh .... inflating: OPatch/opatchprereqs/opatch/rulemap.xml inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml inflating: OPatch/opatch oracle@testdb:/backup/ORACLE/19.25_patches > oracle@testdb:/backup/ORACLE/19.25_patches >unzip p36916690_190000_AIX64-5L.zip Archive: p36916690_190000_AIX64-5L.zip creating: 36916690/ creating: 36916690/36912597/ creating: 36916690/36912597/etc/ creating: 36916690/36912597/etc/config/ inflating: 36916690/36912597/etc/config/inventory.xml inflating: 36916690/36912597/etc/config/stringsubs.xml inflating: 36916690/36912597/etc/config/actions.xml .... inflating: 36916690/automation/bp1-out-of-place-switchback.xml inflating: 36916690/automation/bp1-out-of-place-non-rolling-switchback.xml inflating: 36916690/automation/messages.properties inflating: PatchSearch.xml oracle@JBHOOEMDB:/backup/ORACLE/19.25_patches >unzip p36878697_190000_AIX64-5L.zip Archive: p36878697_190000_AIX64-5L.zip creating: 36878697/ creating: 36878697/files/ creating: 36878697/files/rdbms/ creating: 36878697/files/rdbms/lib/ inflating: 36878697/files/rdbms/lib/joxoff.o ...... creating: 36878697/etc/config/ inflating: 36878697/etc/config/actions.xml inflating: 36878697/etc/config/inventory.xml inflating: 36878697/README.html inflating: PatchSearch.xml Step 3: You can check the prerequisites and apply the patches by oracle user. oracle@testdb:/backup/ORACLE/19.25_patches/36916690/36917397 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ oracle@testdb:/backup/ORACLE/19.25_patches/36916690/36917416 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ oracle@testdb:/backup/ORACLE/19.25_patches/36916690/36912597 >opatch prereq CheckConflictAgainstOHWithDetail -ph ./ oracle@testdb: >env | grep ORA ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 ORACLE_SID=oemdb oracle@testdb:/backup/ORACLE/19.25_patches/36916690/36912597 >opatch apply -silent Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-06-23_12-22-37PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36912597 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36912597' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.201.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.rdbms.util, 19.0.0.0.0... Patching component oracle.rdbms.rsf, 19.0.0.0.0... Patching component oracle.assistants.acf, 19.0.0.0.0... Patching component oracle.assistants.deconfig, 19.0.0.0.0... Patching component oracle.assistants.server, 19.0.0.0.0... Patching component oracle.blaslapack, 19.0.0.0.0... Patching component oracle.buildtools.rsf, 19.0.0.0.0... Patching component oracle.ctx, 19.0.0.0.0... Patching component oracle.dbdev, 19.0.0.0.0... Patching component oracle.dbjava.ic, 19.0.0.0.0... Patching component oracle.dbjava.jdbc, 19.0.0.0.0... Patching component oracle.dbjava.ucp, 19.0.0.0.0... Patching component oracle.duma, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... Patching component oracle.ldap.owm, 19.0.0.0.0... Patching component oracle.ldap.rsf, 19.0.0.0.0... Patching component oracle.ldap.security.osdt, 19.0.0.0.0... Patching component oracle.marvel, 19.0.0.0.0... Patching component oracle.network.rsf, 19.0.0.0.0... Patching component oracle.odbc.ic, 19.0.0.0.0... Patching component oracle.ons, 19.0.0.0.0... Patching component oracle.ons.ic, 19.0.0.0.0... Patching component oracle.oracore.rsf, 19.0.0.0.0... Patching component oracle.perlint, 5.28.1.0.0... Patching component oracle.precomp.common.core, 19.0.0.0.0... Patching component oracle.precomp.rsf, 19.0.0.0.0... Patching component oracle.rdbms.crs, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms.deconfig, 19.0.0.0.0... Patching component oracle.rdbms.oci, 19.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0... Patching component oracle.rdbms.scheduler, 19.0.0.0.0... Patching component oracle.rhp.db, 19.0.0.0.0... Patching component oracle.rsf, 19.0.0.0.0... Patching component oracle.sdo, 19.0.0.0.0... Patching component oracle.sdo.locator.jrf, 19.0.0.0.0... Patching component oracle.sqlplus, 19.0.0.0.0... Patching component oracle.sqlplus.ic, 19.0.0.0.0... Patching component oracle.wwg.plsql, 19.0.0.0.0... Patching component oracle.xdk.rsf, 19.0.0.0.0... Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.xdk.xquery, 19.0.0.0.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.ovm, 19.0.0.0.0... Patching component oracle.oraolap, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0... Patching component oracle.rdbms.rat, 19.0.0.0.0... Patching component oracle.ldap.rsf.ic, 19.0.0.0.0... Patching component oracle.rdbms.dv, 19.0.0.0.0... Patching component oracle.xdk, 19.0.0.0.0... Patching component oracle.mgw.common, 19.0.0.0.0... Patching component oracle.ldap.client, 19.0.0.0.0... Patching component oracle.install.deinstalltool, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.oraolap.api, 19.0.0.0.0... Patching component oracle.dbtoolslistener, 19.0.0.0.0... Patching component oracle.rdbms.drdaas, 19.0.0.0.0... Patching component oracle.rdbms.hs_common, 19.0.0.0.0... Patching component oracle.rdbms.lbac, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.rdbms.dm, 19.0.0.0.0... Patching component oracle.ldap.ssl, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 19.0.0.0.0... Patching component oracle.odbc, 19.0.0.0.0... Patching component oracle.network.listener, 19.0.0.0.0... Patching component oracle.ctx.atg, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.rdbms.hsodbc, 19.0.0.0.0... Patching component oracle.network.aso, 19.0.0.0.0... Patching component oracle.rdbms.locator, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.precomp.common, 19.0.0.0.0... Patching component oracle.precomp.lang, 19.0.0.0.0... Patching component oracle.jdk, 1.8.0.5.201... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeout64 ld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeout64 ld: 0711-224 WARNING: Duplicate symbol: .bcopy_wrapper .... ld: 0711-773 WARNING: Object /lib/crt0_64.o, imported symbol p_xrcfg Symbol was expected to be local. Extra instructions are being generated to reference the symbol. ld: 0711-773 WARNING: Object /lib/crt0_64.o, imported symbol p_xrc Symbol was expected to be local. Extra instructions are being generated to reference the symbol. Patch 36912597 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-06-23_12-22-37PM_1.log oracle@testdb:/backup/ORACLE/19.25_patches/36878697 >opatch apply -silent Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-06-23_12-34-19PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36878697 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36878697' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.javavm.server.core, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-415 WARNING: Symbol ldxdts is already exported. ld: 0711-415 WARNING: Symbol ldxsto is already exported. ld: 0711-415 WARNING: Symbol lnxadd is already exported. ld: 0711-415 WARNING: Symbol lnxcopy is already exported. ld: 0711-415 WARNING: Symbol lnxmin is already exported. ld: 0711-415 WARNING: Symbol lnxmul is already exported. ..... ld: 0711-786 WARNING: TLS overflow. TLS size: 361088 Maximum size: 65536 Extra instructions are being generated for some direct references to TLS symbols. Patch 36878697 successfully applied. OPatch Session completed with warnings. oracle@JBHOOEMDB:/backup/ORACLE/19.25_patches/36916690/36917416 >opatch apply -silent Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-06-23_12-30-59PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36917416 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '36917416' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.deconfig, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.has.db, 19.0.0.0.0... Patching component oracle.has.db.cvu, 19.0.0.0.0... Patching component oracle.has.common.cvu, 19.0.0.0.0... Patching component oracle.has.common, 19.0.0.0.0... Patching component oracle.rhp.common, 19.0.0.0.0... Patching component oracle.has.rsf, 19.0.0.0.0... Patching component oracle.rhp.db, 19.0.0.0.0... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-224 WARNING: Duplicate symbol: .vsn_getVersion ld: 0711-224 WARNING: Duplicate symbol: vsn_getVersion ..... ld: 0711-224 WARNING: Duplicate symbol: .kgup_error_init ld: 0711-224 WARNING: Duplicate symbol: .kgup_mes_get ld: 0711-224 WARNING: Duplicate symbol: .kgucrsh ld: 0711-224 WARNING: Duplicate symbol: p_xrcfg ld: 0711-224 WARNING: Duplicate symbol: p_xrc ld: 0711-773 WARNING: Object /lib/crt0_64.o, imported symbol p_xrcfg Symbol was expected to be local. Extra instructions are being generated to reference the symbol. ld: 0711-773 WARNING: Object /lib/crt0_64.o, imported symbol p_xrc Symbol was expected to be local. Extra instructions are being generated to reference the symbol. Patch 36912597 successfully applied. OPatch Session completed with warnings. Crosscheck the applied patches using "opatch lspatches" command. oracle@testdb:/backup/ORACLE/19.25_patches/36878697 >opatch lspatches 36878697;OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697) 36917416;OCW RELEASE UPDATE 19.25.0.0.0 (36917416) 36912597;Database Release Update : 19.25.0.0.241015 (36912597) Step 4: After applying all patches to RDBMS HOME, start the RDBMS services including DB and listeners. oracle@testdb:/home/oracle >sqlplus /as as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 23 12:36:54 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to an idle instance. SQL> startup; ORACLE instance started. Total System Global Area 1.5032E+10 bytes Fixed Size 18582344 bytes Variable Size 2046820352 bytes Database Buffers 1.2952E+10 bytes Redo Buffers 14942208 bytes Database mounted. Database opened. SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- ------------ OEMDB READ WRITE Step 5: Now as a part of post patching steps, you can execute "datapatch -verbose" command. Note: Please note that do not execute "datapatch -verbose" command when your business is running. This can sometimes creates performance problems in OLTP databases an blocking issues and hence it is recommended to run this during non-business hours. oracle@testdb:/home/oracle >cd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch oracle@testdb:/u01/app/oracle/product/19.0.0/dbhome_1/OPatch >./datapatch -verbose SQL Patching tool version 19.25.0.0.0 Production on Mon Jun 23 12:37:59 2025 Copyright (c) 2012, 2024, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_20185398_2025_06_23_12_37_59/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Bootstrapping registry and package to current versions...done Determining current state...done Current state of interim SQL patches: Interim patch 36878697 (OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)): Binary registry: Installed SQL registry: Not installed Current state of release update SQL patches: Binary registry: 19.25.0.0.0 Release_Update 241017123525: Installed SQL registry: Applied 19.14.1.0.0 Release_Update_Revision 220407194723 successfully on 19-JUN-25 06.23.29.511170 PM Adding patches to installation queue and performing prereq checks...done Installation queue: No interim patches need to be rolled back Patch 33806138 (Database Release Update Revision : 19.14.1.0.220419 (33806138)): Rollback from 19.14.1.0.0 Release_Update_Revision 220407194723 to 19.14.0.0.0 Release_Update 211228142955 Patch 36912597 (Database Release Update : 19.25.0.0.241015 (36912597)): Apply from 19.14.0.0.0 Release_Update 211228142955 to 19.25.0.0.0 Release_Update 241017123525 The following interim patches will be applied: 36878697 (OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)) Installing patches... Patch installation complete. Total patches installed: 3 Validating logfiles...done Patch 33806138 rollback: SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33806138/24749677/33806138_rollback_OEMDB_2025Jun23_12_39_26.log (no errors) Patch 36912597 apply: SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36912597/25893878/36912597_apply_OEMDB_2025Jun23_12_39_39.log (no errors) Patch 36878697 apply: SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36878697/25812827/36878697_apply_OEMDB_2025Jun23_12_38_49.log (no errors) SQL Patching tool complete on Mon Jun 23 12:44:09 2025 You can verify the results by executing below SQL query. oracle@testdb:/home/oracle >sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 23 12:44:39 2025 Version 19.25.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.25.0.0.0 SQL> set lines 300 pages 3000 SQL> col ACTION_TIME for a33 SQL> col DESCRIPTION for a30 SQL> col status for a10 SQL> select PATCH_ID,PATCH_TYPE,ACTION,status,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch; PATCH_ID PATCH_TYPE ACTION STATUS ACTION_TIME DESCRIPTION -------- ---------- -------- ---------- ----------------------------- ------------------------------ 33806138 RUR APPLY SUCCESS 19-JUN-25 06.23.29.511170 PM Database Release Update Revision : 19.14.1.0.220419 (33806138) 36878697 INTERIM APPLY SUCCESS 23-JUN-25 12.39.26.648781 PM OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697) 33806138 RUR ROLLBACK SUCCESS 23-JUN-25 12.39.39.152394 PM Database Release Update Revision : 19.14.1.0.220419 (33806138) 36912597 RU APPLY SUCCESS 23-JUN-25 12.43.30.988381 PM Database Release Update : 19.25.0.0.241015 (36912597) |
Thanks for reading this post ! Please comment if you like this post ! Click FOLLOW to get future blog updates !
Thank you for visiting my blog ! Thanks for your comment !