Step 1 - Update the Oracle Database Appliance Repository with Latest Patches

Refer to the Oracle Database Appliance Release Notes for the latest Oracle Database appliance patches.

You must download the server patch file for Oracle Database appliance release 19.17. The server patch updates the firmware and operating system.  You must patch the server before you patch the databases.  When patching databases, you can choose to patch a subset, if required. However, it is recommended to patch all databases to keep them current. 

For this lab, we have downloaded simulated 19.17.0.0.0 patches for the server, Oracle Grid Infrastructure, and database clone files to your simulator. 

You must update the repositories with the latest server patch, Oracle Grid Infrastructure, and database clone files, as well as additional applicable database clone files.  For example, if you plan to patch Oracle Database from release 19.16 to 19.17, you must update the repository with the 19.16 Oracle Grid Infrastructure and database clone files first.

Before you start patching the server, you can check the current installed components from the web console.  Go to the Appliance tab, click on Patch Manager on the left, and then click the Update Server/Storage tab.  Note all the installed 19.16.0.0.0 components.  Since you have not updated the repository to 19.17.0.0.0, all components are displayed as up to date.

Next, update the server repository.  The server patch file is oda-sm-19.17.0.0.0-date-server.zip.

$ odacli update-repository -f /opt/oracle/dcs/patchfiles/oda-sm-19.17.0.0.0-date-server.zip 

{
  "jobId" : "b3794603-4fbb-42a4-89ee-791d420e68a6",
  "status" : "Running",
  "message" : "/opt/oracle/dcs/patchfiles/oda-sm-19.16.0.0.0-date-server.zip",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 06:29:42 AM UTC",
  "resourceList" : [ ],
  "description" : "Repository Update",
  "updatedTime" : "September 26, 2022 06:29:42 AM UTC"
}

For an actual Oracle Database Appliance, you may need to update the DCS agent first, before updating repository with the 19.16 Oracle Grid Infrastructure and database clone files, if you want to create a 19.16 database or patch a database to 19.16. See the Oracle Database Appliance Deployment and User's Guide for your hardware model.

Run the following commands to update the Oracle Database Appliance repository with these patches.  You must use the full path for the file names.

$ odacli update-repository -f /opt/oracle/dcs/patchfiles/odacli-dcs-19.17.0.0.0-date-GI-19.17.0.0.zip 

{
  "jobId" : "529141f1-c5fb-42a6-ad1e-0b5540781a71",
  "status" : "Waiting",
  "message" : "/opt/oracle/dcs/patchfiles/odacli-dcs-19.17.0.0.0-date-GI-19.17.0.0.zip",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 06:32:43 AM UTC",
  "resourceList" : [ ],
  "description" : "Repository Update",
  "updatedTime" : "September 26, 2022 06:32:43 AM UTC"
}

$ odacli update-repository -f /opt/oracle/dcs/patchfiles/odacli-dcs-19.17.0.0.0-date-GI-19.17.0.0.zip

{
  "jobId" : "6478c708-bef8-4d5a-83a6-b411fe9b3e7d",
  "status" : "Running",
  "message" : "/opt/oracle/dcs/patchfiles/odacli-dcs-19.17.0.0.0-date-DB-19.17.0.0.zip",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 06:33:13 AM UTC",
  "resourceList" : [ ],
  "description" : "Repository Update",
  "updatedTime" : "September 26, 2022 06:33:13 AM UTC"
}

$ odacli update-repository -f /opt/oracle/dcs/patchfiles/odacli-dcs-19.15.0.0.0-date-DB-12.2.0.1.zip

{
  "jobId" : "76e5156b-160f-41fc-b9aa-580992902d9f",
  "status" : "Running",
  "message" : "/opt/oracle/dcs/patchfiles/odacli-dcs-19.15.0.0.0-date-DB-12.2.0.1.zip",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 07:06:26 AM UTC",
  "resourceList" : [ ],
  "description" : "Repository Update",
  "updatedTime" : "September 26, 2022 07:06:27 AM UTC"
}

After you update the repository, you can use the web console to see the 19.17.0.0.0 available component versions.