wagnerjer

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
  

1. Extract the zipped files in a folder
2. Install the Windows Database bundle patch
3. 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

cd c:\temp\extracted-patch-folder
c:\Oracle\product\xxx\Opatch\opatch prereq CheckConflictAgainstOHWithDetail -ph ./