This is an old revision of the document!
- Download the required patches to perform update
Latest versions can be found on the following page: https://support.oracle.com/knowledge/Oracle%20Cloud/2521164_1.html
Windows Bundle Patch - R19x Database Release Update Revision, column "Included in Windows Bundle" OJVM - R19x OJVM Release Update
Note: Windows patches release date might be delayed of other patches. You can find real release dates on the following link: https://dbsguru.com/oracle-critical-database-patch-id-jan-2024/
Once patches numbers are noted you can download from the support page: https://support.oracle.com
- Install patches on Windows server
- Extract the zipped files in a folder
- Install the Windows Database bundle patch
- Install OJVM
Installation of the Windows Database bundle patch:
- Check if there are any invalid packages
Start CMD as administrator
sqlplus /nolog SQL> connect as sysdba Enter user-name: sys Enter password:***** Connected SQL> set line 2000 SQL> select owner, object_type, object_name,status from dba_objects where status != 'VALID' order by owner, object_type;
- Check if there is any conflict with any installed patch
Start CMD as administrator Navigate to the folder where you extracted the Windows Bundle Patch and run the command to check for any conflict from that folder <cli type=dos>cd c:\temp\extracted-patch-folder c:\Oracle\product\xxx\Opatch\opatch prereq CheckConflictAgainstOHWithDetail -ph ./