Install Oracle 19c Windows October 2024 patch
This section includes the following patches:
36878821 - Windows Database Oct2024 Bundle Patch 19.25.0.0.241015.
36878697 - Oracle JavaVM Component Release Update 19.25.0.0.241015.
36866578 - UPDATE 19.0.0.0.0 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8u431.
Note:
Verify that the Oracle OPatch utility version is latest.
We include 4 files and the following are the steps to install and verify the patches which needs to be executed in the order they are specified.
Download the patch files and follow the pre-install setup.
Upgrade OPatch.
Install the patches.
Verify the database and OJVM patch.
Verify the JDK version updates.
Pre-install setup
- Make a note of the latest Oracle OJVM patch installed from the System Health Check report in the section Oracle Patch History.
Note:
If you have applied any of the OJVM patches before, then you will have to roll back the previous OJVM patch. Example the last applied OJVM patch was OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646), then it needs to be rolled back and the instruction to rollback is provided later under section Installing the Oracle patches step -7. If no prior OJVM patch found or if it is not 35648110 patch, then no rollback is needed.
- Log in to the virtual machine or Server where IT Analytics is installed.
- Download the following files from the product download area of the website and save to C:\temp folder.
p6880880_190000_MSWIN-x86-64.zip
p36878821_190000_MSWIN-x86-64.zip (Database Bundle Patch)
p36878697_190000_MSWIN-x86-64.zip (OJVM Patch)
p36866578_190000_MSWIN-x86-64.zip (JDK Bundle Patch)
- Access the command prompt as an Administrator.
- Verify %ORACLE_HOME%\perl\bin is displayed in your PATH setting.
Note:
If not displayed in your PATH setting, enter the following:
set PATH=%ORACLE_HOME%\perl\bin;%PATH%
- Set the Perl library path to empty.
set perl5lib=
OPatch installation
- Change directory to the Oracle home directory.
- Execute command cd C:\opt\oracle.
- Rename the existing OPatch directory using the following command.
rename Opatch Opatch_old
- Unzip the file p6880880_190000_MSWIN-x86-64.zip in C:\opt\oracle.
- Execute the following command to verify the opatch version.
C:\opt\oracle\OPatch>opatch version.
OPatch Version: 12.2.0.1.43
Note:
OPatch succeeded message is displayed.
Installing the patches
- Shut down IT Analytics services by executing the following .bat file.
C:\opt\aptare\utils\stopallservices.batNote:
Verify that all the IT Analytics services are stopped by checking in services. If services are still running, the patch installation will not be successful and will cause issues.
- Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running using the following command.
net stop msdtc.
- Unzip
p36878821_190000_MSWIN-x86-64.zipat C:\opt\oracle. - Unzip
p36878697_190000_MSWIN-x86-64.zipatC:\opt\oracle. - Unzip
p36866578_190000_MSWIN-x86-64.zipatC:\opt\oracle. - Set PATH using the following command.
set PATH=%ORACLE_HOME%\opatch;%PATH%
- If the last OJVM patch, for example, was 19.24.0.0.240716 (36414915), then rollback by executing the
opatch rollback -id 36414915 command and follow the steps to rollback.
- Navigate to the database bundle patch folder using the following command:
cd C:\opt\oracle\36878821
- Check for any OPatch conflicts using the following command for the Database Bundle patch.
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
- If no conflict is detected, execute the following command from the folder
C:\opt\oracle\36878821..C:\opt\oracle\36878821\opatch apply
- Follow the prompts to apply the database bundle patch.
Note:
After unzipping the patch on the server, the readme file is located at:
C:\opt\oracle\36878821 - Navigate to the OJVM patch folder using the following command:
cd C:\opt\oracle\36878697
- Verify any OPatch conflicts for the OJVM patch using the following command:
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
- If no conflict is detected, from the folder
C:\opt\oracle\36878697, execute the following command:C:\opt\oracle\36878697\opatch apply
- Follow the prompts to apply the OJVM patch.
Note:
After unzipping the patch on the server, the readme file is located at:
C:\opt\oracle\36878697 - Navigate to the JDK patch folder using the following command
cd C:\opt\oracle\36866578.
- Verify the OPatch conflicts using the following command for the JDK bundle patch.
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
- If no conflicts are detected, execute the following command from the folder
C:\opt\oracle\36866578..C:\opt\oracle\36866578\opatch apply
- Follow the prompts to apply the JDK Bundle patch.
Note:
After unzipping the patch on the server, the readme file is located at:
C:\opt\oracle\36866578. - Verify OPatch succeeded using the following commands which will show the OPatch application results of database, OJVM and JDK patches:
C:\opt\oracle\OPatch\opatch lsinventory -detail
- Start IT Analytics Oracle service by executing the following:
C:\opt\aptare\utils\startoracle.bat
- Re-start the Distributed Transaction Coordinator service, which is not an Oracle service, using the following command.
net start msdtc
- Connect to SQL Plus using the following command:
Note:
This step requires the database to be running including the pluggable database.
sqlplus / as sysdba
alter pluggable database all open;
quit
- Execute the following command to complete the post-install SQL deployment for the patch being installed. This data patch command applies the patch to the pluggable database.
C:\opt\Oracle\Opatch\datapatch -verbose
- Check the following log files in
C:\opt\oracle\cfgtoollogs\opatchfor errors. The log file name includes the current timestamp.For example:
opatch202411-04_19-07-05PM_1.log. - Start all the IT Analytics services, including Oracle, by executing the following.
C:\opt\aptare\utils\startallservices.bat
Validating the database and OJVM Patches
- Connect to SQL Plus using the following command.
sqlplus / as sysdba
- Query to check registry for patch history.
SQL>select * from sys.registry$history;
- Query to check registry for installed patch.
SQL>select * from sys.registry$sqlpatch ;
- Report output with patch details:
SQL> set serveroutput on
SQL> exec dbms_qopatch.get_sqlpatch_status;
Patch Id : 34411846 Action : APPLY Action Time : 16-NOV-2022 14:08:03 Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846) Logfile : C:\opt\cfgtoollogs\sqlpatch\34411846\24997534/34411846_ apply_SCDBCNTR_CDBROOT_2022Nov16_14_02_11.log Status : SUCCESS Patch Id : 34468114 Action : APPLY Action Time : 16-NOV-2022 14:08:03 Description : Windows Database Bundle Patch : 19.17.0.0.221018 (34468114) Logfile : C:\opt\cfgtoollogs\sqlpatch\34468114\24926261/34468114_ apply_SCDBCNTR_CDBROOT_2022Nov16_14_02_11.log Status : SUCCESS Patch Id : 34411846 Action : ROLLBACK Action Time : 28-MAR-2023 18:15:08 Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846) Logfile : C:\opt\cfgtoollogs\sqlpatch\34411846\24997534/34411846_ rollback_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log Status : SUCCESS Patch Id : 34786990 Action : APPLY Action Time : 28-MAR-2023 18:15:09 Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990) Logfile : C:\opt\cfgtoollogs\sqlpatch\34786990\25141362/34786990_ apply_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log Status : SUCCESS Patch Id : 34750795 Action : APPLY Action Time : 28-MAR-2023 18:15:09 Description : Windows Database Bundle Patch : 19.18.0.0.230117 (34750795) Logfile : C:\opt\cfgtoollogs\sqlpatch\34750795\25040762/34750795_ apply_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log Status : SUCCESS Patch Id : 34786990 Action : ROLLBACK Action Time : 18-OCT-2023 20:58:50 Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990) Logfile : C:\opt\cfgtoollogs\sqlpatch\34786990\25141362/34786990_ rollback_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log Status : SUCCESS Patch Id : 35354406 Action : APPLY Action Time : 18-OCT-2023 20:58:52 Description : OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406) Logfile : C:\opt\cfgtoollogs\sqlpatch\35354406\25338973/35354406_ apply_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log Status : SUCCESS Patch Id : 35348034 Action : APPLY Action Time : 18-OCT-2023 20:58:52 Description : Windows Database Bundle Patch : 19.20.0.0.230718 (35348034) Logfile : C:\opt\cfgtoollogs\sqlpatch\35348034\25299325/35348034_ apply_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log Status : SUCCESS Patch Id : 35354406 Action : ROLLBACK Action Time : 06-DEC-2023 17:55:22 Description : OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406) Logfile : C:\opt\cfgtoollogs\sqlpatch\35354406\25338973/35354406_ rollback_SCDBCNTR_CDBROOT_2023Dec06_17_54_23.log Status : SUCCESS Patch Id : 35681552 Action : APPLY Action Time : 06-DEC-2023 17:55:23 Description : Windows Database Bundle Patch : 19.21.0.0.231017 (35681552) Logfile : C:\opt\cfgtoollogs\sqlpatch\35681552\25362844/35681552_ apply_SCDBCNTR_CDBROOT_2023Dec06_17_54_23.log Status : SUCCESS Patch Id : 35648110 Action : APPLY Action Time : 06-DEC-2023 18:52:28 Description : OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110) Logfile : C:\opt\cfgtoollogs\sqlpatch\35648110\25431514/35648110_ apply_SCDBCNTR_CDBROOT_2023Dec06_18_52_25.log Status : SUCCESS Patch Id : 35648110 Action : ROLLBACK Action Time : 17-FEB-2024 00:47:47 Description : OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110) Logfile : C:\opt\cfgtoollogs\sqlpatch\35648110\25431514/35648110_ rollback_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log Status : SUCCESS Patch Id : 35926646 Action : APPLY Action Time : 17-FEB-2024 00:47:48 Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646) Logfile : C:\opt\cfgtoollogs\sqlpatch\35926646\25549578/35926646_ apply_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log Status : SUCCESS Patch Id : 35962832 Action : APPLY Action Time : 17-FEB-2024 00:47:48 Description : Windows Database Bundle Patch : 19.22.0.0.240116 (35962832) Logfile : C:\opt\cfgtoollogs\sqlpatch\35962832\25463642/35962832_ apply_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log Status : SUCCESS Patch Id : 35926646 Action : ROLLBACK Action Time : 21-MAY-2024 20:36:23 Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646) Logfile : C:\opt\cfgtoollogs\sqlpatch\35926646\25549578/35926646_ rollback_SCDBCNTR_CDBROOT_2024May21_20_36_23.log Status : SUCCESS Patch Id : 36199232 Action : APPLY Action Time : 21-MAY-2024 20:36:23 Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232) Logfile : C:\opt\cfgtoollogs\sqlpatch\36199232\25655176/36199232_ apply_SCDBCNTR_CDBROOT_2024May21_20_36_23.log Status : SUCCESS Patch Id : 36219938 Action : APPLY Action Time : 21-MAY-2024 20:36:49 Description : Windows Database Bundle Patch : 19.23.0.0.240416 (36219938) Logfile : C:\opt\cfgtoollogs\sqlpatch\36219938\25594398/36219938_ apply_SCDBCNTR_CDBROOT_2024May21_20_36_23.log Status : SUCCESS Patch Id : 36199232 Action : ROLLBACK Action Time : 05-AUG-2024 19:23:23 Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232) Logfile : C:\opt\cfgtoollogs\sqlpatch\36199232\25655176/36199232_ rollback_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log Status : SUCCESS Patch Id : 36414915 Action : APPLY Action Time : 05-AUG-2024 19:23:23 Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915) Logfile : C:\opt\cfgtoollogs\sqlpatch\36414915\25762332/36414915_ apply_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log Status : SUCCESS Patch Id : 36521936 Action : APPLY Action Time : 05-AUG-2024 19:24:08 Description : Windows Database Bundle Patch : 19.24.0.0.240716 (36521936) Logfile : C:\opt\cfgtoollogs\sqlpatch\36521936\25687085/36521936_ apply_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log Status : SUCCESS Patch Id : 36414915 Action : ROLLBACK Action Time : 04-NOV-2024 19:23:03 Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915) Logfile : C:\opt\cfgtoollogs\sqlpatch\36414915\25762332/36414915_ rollback_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log Status : SUCCESS Patch Id : 36878697 Action : APPLY Action Time : 04-NOV-2024 19:23:03 Description : OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697) Logfile : C:\opt\cfgtoollogs\sqlpatch\36878697\25899910/36878697_ apply_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log Status : SUCCESS Patch Id : 36878821 Action : APPLY Action Time : 04-NOV-2024 19:23:20 Description : Windows Database Bundle Patch : 19.25.0.0.241015 (36878821) Logfile : C:\opt\cfgtoollogs\sqlpatch\36878821\25823470/36878821_ apply_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log Status : SUCCESS PL/SQL procedure successfully completed.
Note:
If any previous patches are applied, those patch id will be displayed here.
- Exit from SQL prompt:
SQL>exit
Validating the JDK version updates
- C:\opt\oracle\jdk\bin\java -version
java version "1.8.0_431"
Java(TM) SE Runtime Environment (build 1.8.0_431-b10)
Java HotSpot(TM) 64-Bit Server
VM (build 25.431-b10, mixed mode)
- C:\opt\oracle\Opatch\jre\bin\java -version
java version "1.8.0_431"
Java(TM) SE Runtime Environment (build 1.8.0_431-b10)
Java HotSpot(TM) 64-Bit Server
VM (build 25.431-b10, mixed mode)