Patching Oracle Data Integrator 14c
This blog post shows how to install the latest Oracle Data Integrator 14c patches.
Table of Contents
Downloading the patches
We will apply the following patches to the already installed ODI system:
- ODI Stack Patch Bundle 14.1.2.0.250713 (p38184759)
- ODIMP Bundle Patch 14.1.2.0.250709 (p38172533)
- UMS BUNDLE PATCH 14.1.2.0.250604 (p38032126)
This will update the system from version 14.1.2.0.0 to 14.1.2.0.250713. The patches should be downloaded from the Oracle Support portal and placed in a directory accesible from the VM (/sw/oracle/odi/patch in my case).
Installing the patches
The following commands can be used to unpack and install the patches (this takes about 30 minutes):
# run as user root
# unpack the patches
su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38184759_141200_Generic.zip'
su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38172533_141200_Generic.zip'
su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38032126_141200_Generic.zip'
# stop the application and the database
stopodi.sh f
# perform a patch precheck (optional) of the Stack Bundle Patch
su - oracle -c '/home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/spbat.sh -phase precheck -oracle_home /home/oracle/Oracle/Middleware/Oracle_Home'
# apply the Stack Bundle Patch
# the logfiles will be located here: /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/
su - oracle -c '/home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/spbat.sh -phase apply -oracle_home /home/oracle/Oracle/Middleware/Oracle_Home'
# verify the installed patches
su - oracle -c 'ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch lspatches'
# install the ODIMP Bundle Patch
su - oracle -c 'export ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; cd 38172533; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch apply -silent'
# install the UMS BUNDLE PATCH
su - oracle -c 'export ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; cd 38032126; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch apply -silent'
# re apply our previous fixes
cat >>/home/oracle/Oracle/Middleware/Oracle_Home/odi/studio/bin/odi.conf <<EOF
AddVMOption -Duser.timezone=Europe/Berlin
AddVMOption -Djavax.net.ssl.trustStore=/home/oracle/Oracle/Middleware/Oracle_Home/wlserver/server/lib/DemoTrust.jks
AddVMOption -Djavax.net.ssl.trustStoreType=JKS
AddVMOption -Djavax.net.ssl.trustStorePassword=DemoTrustKeyStorePassPhrase
EOF
# start the database
su - grid -c 'source grid.env; crsctl start res -all'
Sample Output (click to expand):
[root@lin7 ~]# # run as user root
[root@lin7 ~]# # unpack the patches
[root@lin7 ~]# su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38184759_141200_Generic.zip'
[root@lin7 ~]# su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38172533_141200_Generic.zip'
[root@lin7 ~]# su - oracle -c 'unzip -q /sw/oracle/odi/patch/p38032126_141200_Generic.zip'
[root@lin7 ~]#
[root@lin7 ~]# # stop the application and the database
[root@lin7 ~]# stopodi.sh
stopping the ManagedServer...
Stopping Weblogic Server...
Java HotSpot(TM) 64-Bit Server VM warning: Archived non-system classes are disabled because the java.system.class.loader property is specified (value = "com.oracle.classloader.weblogic.LaunchClassLoader"). To use archived non-system classes, this property must not be set
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3s://11.1.1.195:9002 with userid wladmin ...
<Sep 3, 2025, 2:20:15 PM Central European Summer Time> <Info> <Security> <BEA-090908> <Using the default WebLogic SSL Wildcard Hostname Verifier implementation.>
Successfully connected to Admin Server "AdminServer" that belongs to domain "base_domain".
Shutting down the server ODI_server1 with force=false while connected to AdminServer ...
............................................................................................................................
Exiting WebLogic Scripting Tool.
Done
Stopping Derby Server...
Derby server stopped.
stopping the AdminServer...
Stopping Weblogic Server...
Java HotSpot(TM) 64-Bit Server VM warning: Archived non-system classes are disabled because the java.system.class.loader property is specified (value = "com.oracle.classloader.weblogic.LaunchClassLoader"). To use archived non-system classes, this property must not be set
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3s://11.1.1.195:9002 with userid wladmin ...
<Sep 3, 2025, 2:22:41 PM Central European Summer Time> <Info> <Security> <BEA-090908> <Using the default WebLogic SSL Wildcard Hostname Verifier implementation.>
Successfully connected to Admin Server "AdminServer" that belongs to domain "base_domain".
Shutting down the server AdminServer with force=false while connected to AdminServer ...
.WLST lost connection to the WebLogic Server that you were connected to.
This may happen if the server was shut down or partitioned.
You will have to re-connect to the server once the server is available.
Disconnected from weblogic server: AdminServer
Disconnected from weblogic server: AdminServer
Exiting WebLogic Scripting Tool.
Done
Stopping Derby Server...
Derby server stopped.
stopping the NodeManager...
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <NODEMGR_HOME is already set to /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager>
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <Begin>
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <Adding NodeManagerHome entry to JAVA_OPTIONS: -DNodeManagerHome=/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager>
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <Root Directory already set /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain>
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <Found process id from /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager/nodemanager.process.id: 11075>
<2025-09-03 CEST 14:22:47> <Info> <StopNodeManager> <Sending signal TERM to 11075>
<2025-09-03 CEST 14:22:48> <Info> <StopNodeManager> <End>
/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager/stopnodemanager.log was copied to /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager/nodemanager.log
stopping the Database...
CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running
CRS-2500: Cannot stop resource 'ora.ons' as it is not running
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'lin7'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'lin7'
CRS-2673: Attempting to stop 'ora.orcl.db' on 'lin7'
CRS-2673: Attempting to stop 'ora.evmd' on 'lin7'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'lin7'
CRS-2677: Stop of 'ora.DATA.dg' on 'lin7' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'lin7' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'lin7' succeeded
CRS-2677: Stop of 'ora.evmd' on 'lin7' succeeded
CRS-2677: Stop of 'ora.orcl.db' on 'lin7' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'lin7'
CRS-2677: Stop of 'ora.asm' on 'lin7' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'lin7'
CRS-2677: Stop of 'ora.cssd' on 'lin7' succeeded
CRS-4000: Command Stop failed, or completed with errors.
[root@lin7 ~]#
[root@lin7 ~]# # perform a patch precheck (optional) of the Stack Bundle Patch
[root@lin7 ~]# su - oracle -c '/home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/spbat.sh -phase precheck -oracle_home /home/oracle/Oracle/Middleware/Oracle_Home'
SPBAT Release Version: 2.23.0
The current patching user oracle matches with the product install user oracle
-log_dir value is not set, defaulting it to /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs
The consolidated SPBAT execution logs have been written to: /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/orchestration/logs/spbat_2025-09-03_14-23-31.out
Do not close this terminal as SPBAT precheck phase is currently executing...
[2025-09-03_14-23-44] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
[2025-09-03_14-23-45] [INFO] Oracle Home /home/oracle/Oracle/Middleware/Oracle_Home is registered inside /u01/app/oraInventory/ContentsXML/inventory.xml
[2025-09-03_14-23-45] [SUCCESS] /home/oracle/Oracle/Middleware/Oracle_Home Middleware Home is present
[2025-09-03_14-23-45] [SUCCESS] The current jdk release 17.0.16 is a supported JDK release
[2025-09-03_14-23-45] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
[2025-09-03_14-23-46] Minimum OPatch version required : 13.9.4.2.5
[2025-09-03_14-23-46] Environment has OPatch version : 13.9.4.2.17
[2025-09-03_14-23-46] [SUCCESS] Minimum OPatch version check
[2025-09-03_14-23-53] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
[2025-09-03_14-23-53] [SUCCESS] The Installed JDK version 17.0_16 is higher than or same as the recommended JDK version 17.0_16
[2025-09-03_14-23-53] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
[2025-09-03_14-23-55] Middleware OPatch Version : 13.9.4.2.17
[2025-09-03_14-23-55] SPB OPatch version : 13.9.4.2.20
[2025-09-03_14-24-04] Environment has the lower version of OPatch compared to the OPatch binary in SPB
[2025-09-03_14-24-04] OPatch will be upgraded during apply phase
[2025-09-03_14-24-13] List of patches present in the Oracle Home: /home/oracle/Oracle/Middleware/Oracle_Home
36990807;One-off
36964826;One-off
[2025-09-03_14-24-13] Patch compatibility check with the environment is in progress...
[2025-09-03_14-25-24] CheckForNoOpPatches has Completed on /home/oracle/Oracle/Middleware/Oracle_Home Home
[2025-09-03_14-25-32] PATCH 38063775 APPLY WILL BE SKIPPED AS IT IS NOT APPLICABLE FOR THIS ENVIRONMENT
[2025-09-03_14-25-32] PATCH 38184768 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-32] PATCH 38130086 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-33] PATCH 38018960 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-33] PATCH 37887265 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-33] PATCH 37925693 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-34] PATCH 38172533 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-34] PATCH 38101364 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-34] PATCH 38184117 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-35] PATCH 38015961 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-36] PATCH 37669471 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-25-36] Patch conflict check is in progress ...
[2025-09-03_14-25-48] Patch conflict check has completed on /home/oracle/Oracle/Middleware/Oracle_Home Home
[2025-09-03_14-25-48] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
[2025-09-03_14-25-49] Napply precheck report is in progress ...
[2025-09-03_14-27-53] Napply precheck report has SUCCESSFULLY completed for odi patch
[2025-09-03_14-27-53] SPBAT precheck phase has completed. Summary and log details as below:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
PRECHECK SUMMARY:
No Of FAILURES: 0
No Of WARNINGS: 0
[2025-09-03_14-27-53] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_precheck_2025-09-03_14-23-31/spbat-precheck-lin7-2025-09-03_14-23-31.log
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SPBAT precheck phase has completed successfully
Time Taken to run precheck phase: 00 hours 04 min 22 secs
[root@lin7 ~]#
[root@lin7 ~]# # apply the Stack Bundle Patch
[root@lin7 ~]# # the logfiles will be located here: /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/
[root@lin7 ~]# su - oracle -c '/home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/spbat.sh -phase apply -oracle_home /home/oracle/Oracle/Middleware/Oracle_Home'
SPBAT Release Version: 2.23.0
The current patching user oracle matches with the product install user oracle
-log_dir value is not set, defaulting it to /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs
The consolidated SPBAT execution logs have been written to: /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/orchestration/logs/spbat_2025-09-03_14-27-53.out
Do not close this terminal as SPBAT apply phase is currently executing...
[2025-09-03_14-28-06] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-28-07] [INFO] Oracle Home /home/oracle/Oracle/Middleware/Oracle_Home is registered inside /u01/app/oraInventory/ContentsXML/inventory.xml
[2025-09-03_14-28-07] [SUCCESS] /home/oracle/Oracle/Middleware/Oracle_Home Middleware Home is present
[2025-09-03_14-28-08] [SUCCESS] The current jdk release 17.0.16 is a supported JDK release
[2025-09-03_14-28-08] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-28-08] Minimum OPatch version required : 13.9.4.2.5
[2025-09-03_14-28-08] Environment has OPatch version : 13.9.4.2.17
[2025-09-03_14-28-08] [SUCCESS] Minimum OPatch version check
[2025-09-03_14-28-23] STARTED : Performing OPatch upgrade on odi Host
[2025-09-03_14-28-23] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-28-24] Middleware OPatch Version : 13.9.4.2.17
[2025-09-03_14-28-24] SPB OPatch version : 13.9.4.2.20
[2025-09-03_14-29-24] OPatch upgrade has SUCCESSFULLY Completed for odi patch
[2025-09-03_14-29-24] OPatch upgrade Exit Status - 0
[2025-09-03_14-29-24] OPatch upgrade has SUCCEEDED
[2025-09-03_14-29-24] Check the OPatch upgrade log /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/opupg/mw_opatch-opatch-upgrade-2025-09-03_14-28-23.log for more information
[2025-09-03_14-29-24] COMPLETED : Performing OPatch upgrade on odi Home
[2025-09-03_14-29-37] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-29-37] [SUCCESS] The Installed JDK version 17.0_16 is higher than or same as the recommended JDK version 17.0_16
[2025-09-03_14-29-38] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-29-39] Middleware OPatch Version : 13.9.4.2.20
[2025-09-03_14-29-39] SPB OPatch version : 13.9.4.2.20
[2025-09-03_14-29-47] The environment already has the supported version of OPatch installed
[2025-09-03_14-29-56] List of patches present in the Oracle Home: /home/oracle/Oracle/Middleware/Oracle_Home
36990807;One-off
36964826;One-off
[2025-09-03_14-29-56] Patch compatibility check with the environment is in progress...
[2025-09-03_14-31-07] CheckForNoOpPatches has Completed on /home/oracle/Oracle/Middleware/Oracle_Home Home
[2025-09-03_14-31-16] PATCH 38063775 APPLY WILL BE SKIPPED AS IT IS NOT APPLICABLE FOR THIS ENVIRONMENT
[2025-09-03_14-31-17] PATCH 38184768 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-17] PATCH 38130086 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-18] PATCH 38018960 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-18] PATCH 37887265 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-18] PATCH 37925693 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-19] PATCH 38172533 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-19] PATCH 38101364 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-19] PATCH 38184117 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-20] PATCH 38015961 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-21] PATCH 37669471 IS #NOT APPLIED# IN THE ENVIRONMENT
[2025-09-03_14-31-21] Patch conflict check is in progress ...
[2025-09-03_14-31-34] Patch conflict check has completed on /home/oracle/Oracle/Middleware/Oracle_Home Home
[2025-09-03_14-31-34] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
[2025-09-03_14-31-34] Napply precheck report is in progress ...
[2025-09-03_14-33-30] Napply precheck report has SUCCESSFULLY completed for odi patch
[2025-09-03_14-33-30] SPBAT precheck phase has completed. Summary and log details as below:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
PRECHECK SUMMARY:
No Of FAILURES: 0
No Of WARNINGS: 0
[2025-09-03_14-33-30] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[2025-09-03_14-33-37] Application of patches is in progress ...
[2025-09-03_14-42-24] SUCCESSFUL - OPatch napply has completed for odi Home
[2025-09-03_14-42-24] Opatch Napply Exit Status - 0
[2025-09-03_14-42-24] COMPLETED : Performing SPBAT Binary patching on odi Home
[2025-09-03_14-42-30] STARTED : Performing SPBAT binary audit on odi Home
[2025-09-03_14-42-42] NoOp patch#38063775# detected in Environment.Skipping Audit for the same
[2025-09-03_14-42-43] SUCCESSFUL - SPB PATCH 38184768 IS #APPLIED#
[2025-09-03_14-42-43] SUCCESSFUL - SPB PATCH 38130086 IS #APPLIED#
[2025-09-03_14-42-43] SUCCESSFUL - SPB PATCH 38018960 IS #APPLIED#
[2025-09-03_14-42-44] SUCCESSFUL - SPB PATCH 37887265 IS #APPLIED#
[2025-09-03_14-42-44] SUCCESSFUL - SPB PATCH 37925693 IS #APPLIED#
[2025-09-03_14-42-45] SUCCESSFUL - SPB PATCH 38172533 IS #APPLIED#
[2025-09-03_14-42-45] SUCCESSFUL - SPB PATCH 38101364 IS #APPLIED#
[2025-09-03_14-42-46] SUCCESSFUL - SPB PATCH 38184117 IS #APPLIED#
[2025-09-03_14-42-47] SUCCESSFUL - SPB PATCH 38015961 IS #APPLIED#
[2025-09-03_14-42-47] SUCCESSFUL - SPB PATCH 37669471 IS #APPLIED#
[2025-09-03_14-42-58] List of patches present in the Oracle Home: /home/oracle/Oracle/Middleware/Oracle_Home
38184768;ODI Stack Patch Bundle 14.1.2.0.250713 (Patch 38184759)
38184117;OWSM BUNDLE PATCH 14.1.2.0.250712
38172533;ODIMP Bundle Patch 14.1.2.0.250709
38130086;WLS PATCH SET UPDATE 14.1.2.0.250629
38101364;FMW Thirdparty Bundle Patch 14.1.2.0.250620
38018960;Coherence Cumulative Patch 14.1.2.0.3
38015961;ADF BUNDLE PATCH 14.1.2.0.250530
37925693;JDBC23.8 BUNDLE PATCH 14.1.2.0.250521
37887265;RDA release 25.3-2025715 for OFM 14.1.2 SPB
37669471;DATABASE RELEASE UPDATE 23.8.0.0.0 FOR FMW DBCLIENT
[2025-09-03_14-42-58] Log file : /home/oracle/ODI_SPB_14.1.2.0.250713/tools/spbat/generic/SPBAT/logs/lin7_spb_apply_2025-09-03_14-27-53/spbat-apply-lin7-2025-09-03_14-27-53.log
SPBAT apply phase has completed successfully
Time Taken to run apply phase: 00 hours 15 min 05 secs
Perform the post install actions as documented in the SPB README.txt
[root@lin7 ~]#
[root@lin7 ~]# # verify the installed patches
[root@lin7 ~]# su - oracle -c 'ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch lspatches'
38184768;ODI Stack Patch Bundle 14.1.2.0.250713 (Patch 38184759)
38184117;OWSM BUNDLE PATCH 14.1.2.0.250712
38172533;ODIMP Bundle Patch 14.1.2.0.250709
38130086;WLS PATCH SET UPDATE 14.1.2.0.250629
38101364;FMW Thirdparty Bundle Patch 14.1.2.0.250620
38018960;Coherence Cumulative Patch 14.1.2.0.3
38015961;ADF BUNDLE PATCH 14.1.2.0.250530
37925693;JDBC23.8 BUNDLE PATCH 14.1.2.0.250521
37887265;RDA release 25.3-2025715 for OFM 14.1.2 SPB
37669471;DATABASE RELEASE UPDATE 23.8.0.0.0 FOR FMW DBCLIENT
OPatch succeeded.
[root@lin7 ~]#
[root@lin7 ~]# # install the ODIMP Bundle Patch
[root@lin7 ~]# su - oracle -c 'export ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; cd 38172533; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch apply -silent'
Oracle Interim Patch Installer version 13.9.4.2.20
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/Oracle/Middleware/Oracle_Home
Central Inventory : /u01/app/oraInventory
from : /home/oracle/Oracle/Middleware/Oracle_Home/oraInst.loc
OPatch version : 13.9.4.2.20
OUI version : 13.9.4.0.0
Log file location : /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2025-09-03_14-43-10PM_1.log
OPatch detects the Middleware Home as "/home/oracle/Oracle/Middleware/Oracle_Home"
Verifying environment and performing prerequisite checks...
The following patch(es) are duplicate patches with patches installed in the Oracle Home.
[ 38172533]
Incoming patch(es) are better patch(es) with higher UPI(s) or later version(s).
OPatch would rollback installed patches and apply the better ones.
Conflicts/Supersets for each patch are:
Patch : 38172533
Better duplicate of 38172533
Patches [ 38172533 ] will be rolled back.
OPatch continues with these patches: 38172533
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 = '/home/oracle/Oracle/Middleware/Oracle_Home')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '38172533' to OH '/home/oracle/Oracle/Middleware/Oracle_Home'
ApplySession: Optional component(s) [ oracle.odi.jdev.fusiondev, 14.1.2.0.0 ] , [ oracle.odi.jdev.fusiondev, 14.1.2.0.0 ] not present in the Oracle Home or a higher version is found.
Rolling back interim patch '38172533' from OH '/home/oracle/Oracle/Middleware/Oracle_Home'
Patching component oracle.odi.sdk, 14.1.2.0.0...
Patching component oracle.odi.sdk, 14.1.2.0.0...
Patching component oracle.odi.jee, 14.1.2.0.0...
Patching component oracle.odi.jee, 14.1.2.0.0...
Patching component oracle.odi.common, 14.1.2.0.0...
Patching component oracle.odi.agent, 14.1.2.0.0...
Patching component oracle.odi.agent, 14.1.2.0.0...
Patching component oracle.odi.oggstudio, 14.1.2.0.0...
Patching component oracle.odi.studio, 14.1.2.0.0...
Patching component oracle.odi.studio, 14.1.2.0.0...
Patching component oracle.odi.km, 14.1.2.0.0...
Patching component oracle.odi.km, 14.1.2.0.0...
Patching component oracle.odi.tp, 14.1.2.0.0...
RollbackSession removing interim patch '38172533' from inventory
OPatch back to application of the patch '38172533' after auto-rollback.
Patching component oracle.odi.sdk, 14.1.2.0.0...
Patching component oracle.odi.sdk, 14.1.2.0.0...
Patching component oracle.odi.jee, 14.1.2.0.0...
Patching component oracle.odi.jee, 14.1.2.0.0...
Patching component oracle.odi.common, 14.1.2.0.0...
Patching component oracle.odi.agent, 14.1.2.0.0...
Patching component oracle.odi.agent, 14.1.2.0.0...
Patching component oracle.odi.oggstudio, 14.1.2.0.0...
Patching component oracle.odi.studio, 14.1.2.0.0...
Patching component oracle.odi.studio, 14.1.2.0.0...
Patching component oracle.odi.km, 14.1.2.0.0...
Patching component oracle.odi.km, 14.1.2.0.0...
Patching component oracle.odi.tp, 14.1.2.0.0...
Patch 38172533 successfully applied.
OPatch Session completed with warnings.
Log file location: /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2025-09-03_14-43-10PM_1.log
OPatch completed with warnings.
[root@lin7 ~]#
[root@lin7 ~]# # install the UMS BUNDLE PATCH
[root@lin7 ~]# su - oracle -c 'export ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home; cd 38032126; /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch apply -silent'
Oracle Interim Patch Installer version 13.9.4.2.20
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/Oracle/Middleware/Oracle_Home
Central Inventory : /u01/app/oraInventory
from : /home/oracle/Oracle/Middleware/Oracle_Home/oraInst.loc
OPatch version : 13.9.4.2.20
OUI version : 13.9.4.0.0
Log file location : /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2025-09-03_14-45-03PM_1.log
OPatch detects the Middleware Home as "/home/oracle/Oracle/Middleware/Oracle_Home"
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 38032126
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 = '/home/oracle/Oracle/Middleware/Oracle_Home')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '38032126' to OH '/home/oracle/Oracle/Middleware/Oracle_Home'
Patching component oracle.rcu.ucs.messaging, 14.1.2.0.0...
Patching component oracle.rcu.ucs.messaging, 14.1.2.0.0...
Patching component oracle.sdp.messaging, 14.1.2.0.0...
Patch 38032126 successfully applied.
Log file location: /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2025-09-03_14-45-03PM_1.log
OPatch succeeded.
[root@lin7 ~]#
[root@lin7 ~]# # re apply our previous fixes
[root@lin7 ~]# cat >>/home/oracle/Oracle/Middleware/Oracle_Home/odi/studio/bin/odi.conf <<EOF
> AddVMOption -Duser.timezone=Europe/Berlin
> AddVMOption -Djavax.net.ssl.trustStore=/home/oracle/Oracle/Middleware/Oracle_Home/wlserver/server/lib/DemoTrust.jks
> AddVMOption -Djavax.net.ssl.trustStoreType=JKS
> AddVMOption -Djavax.net.ssl.trustStorePassword=DemoTrustKeyStorePassPhrase
> EOF
[root@lin7 ~]#
[root@lin7 ~]# # start the database
[root@lin7 ~]# su - grid -c 'source grid.env; crsctl start res -all'
CRS-2501: Resource 'ora.ons' is disabled
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'lin7'
CRS-2672: Attempting to start 'ora.evmd' on 'lin7'
CRS-2676: Start of 'ora.evmd' on 'lin7' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'lin7' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'lin7'
CRS-2672: Attempting to start 'ora.diskmon' on 'lin7'
CRS-2676: Start of 'ora.diskmon' on 'lin7' succeeded
CRS-2676: Start of 'ora.cssd' on 'lin7' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'lin7'
CRS-2676: Start of 'ora.asm' on 'lin7' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'lin7'
CRS-2672: Attempting to start 'ora.FRA.dg' on 'lin7'
CRS-2676: Start of 'ora.DATA.dg' on 'lin7' succeeded
CRS-2676: Start of 'ora.FRA.dg' on 'lin7' succeeded
CRS-2672: Attempting to start 'ora.orcl.db' on 'lin7'
CRS-2672: Attempting to start 'ora.diskmon' on 'lin7'
CRS-2676: Start of 'ora.diskmon' on 'lin7' succeeded
CRS-2676: Start of 'ora.orcl.db' on 'lin7' succeeded
CRS-4000: Command Start failed, or completed with errors.
[root@lin7 ~]#Perform postinstallation tasks
We start ODI Studio with the following parameter:
# as oracle in a X terminal
studio.sh i
We need to create the https keystores and certificates as described here. After that we can perform KM Object seeding. This is done by connecting to the work repository. ODI Studio will notice that the repository needs to be updated. We confirm that with Yes:
After that is finished we need to update Complex Files. We go to Topology => expand Technologies => right click on “Complex Files” => Import => Import Technology. In the window we select “Synonym Mode INSERT_UPDATE” and select /home/oracle/Oracle/Middleware/Oracle_Home/odi/sdk/xml-reference as the import directory. In the field “Files to import” we check “Complex Files” and clock ok.
We can exit ODI Studio now and finish the update by cleaning the caches and starting the application:
# clear the caches (as root)
rm -rf /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/servers/ODI_server1/{tmp,cache}
# start the application
startodi.sh
We successfully updated Oracle Data Integrator 14c to the latest version:
Leave a Reply