Preparing Oracle DB patch downloads

Complete these steps to prepare for downloading Oracle DB patches.

Procedure

  1. In the BigFix console, click Updates for Linux Applications Middleware site or Updates for Windows Applications Middleware site to view the updates for Fixlets and Tasks.
  2. To view the Fixlets and Tasks, click Sites > External Sites > Updates for Linux Applications Middleware or Updates for Windows Applications Middleware site in the All content pane.
  3. From the Fixlets and Tasks list, select the Precheck or Patch Fixlet item associated with the required patch level to deploy. Then, click the Description tab.
  4. The Fixlet description displays the patch ID that the Fixlet will download.

    Take action
  5. Navigate to support.oracle.com, log in to your account, and then click Patches & Updates. In the Search tab, enter the required information in the Patch Name or Number and Platform fields. Then, click search to find the patch ID from the Fixlet description and download it.

    Take action
  6. The latest OPatch update contains only the patch ID 6880880. Search for this patch ID and make sure it's for the same platform as the main patch ID.
  7. Confirm that the OPatch version in the file listing matches the OPatch version stated in the Fixlet description before you download the OPatch update for Version 19.0.0.0.

    Take action
  8. If you find that the downloaded OPatch version doesn't match the OPatch ID mentioned in the Fixlet description, then you proceed as follows:
    1. Create a custom copy of the patch Fixlet.
    2. Change the OSIZE parameter to match the size of the p680880 patch file size in bytes.
    3. Change the OSHA1 parameter to match the SHA1 hash of the p680880 patch file.
    4. Save this customized copy and use it in place of the original Fixlet.
  9. If you use Windows Oracle DB patch Fixlets, you must download an extra patch. The Fixlet description contains IDs for both the PSU and the OJVM patches.
    Important: You must download both patches because the patching process requires both.

    Take action
  10. After you download all the required files, create the required folder structure in the BigFix Enterprise\BES Server\wwwrootbes\Uploads directory. To create the folder structure:
    1. Create an ORACLE folder in the Uploads folder.
    2. In the ORACLE folder, create a folder with the patch level, for example, 2023-01.
    3. In the patch-level folder, create the following subfolders and copy the patch files into them:
      OPatch: Copy all the p680880 zip files for each OS into this folder.
      SDB: Copy the combo patch zip files for each OS into this folder.
      ASM: Copy the combo grid patch zip files for each OS into this folder if you are patching ASM or RAC.
      OJVM: Copy the OJVM patch zip files for each OS into this folder if you are patching Oracle on Windows.

    Take action