Patching OCI DB Systems OS

 

Update the Operating System of a DB System Node

This topic explains how to use the dbcli to run a precheck and then apply an update to the operating system running on a DB system node (virtual machine).

1. SSH to the DB System.

   ssh -i opc@<db_system_ip_address>

2. Log in as opc and then sudo to the root user. Use sudo su - with a hyphen to invoke the root user's profile, which will set the PATH to the dbcli directory (/opt/oracle/dcs/bin).  

3. sudo su - root

4. [root@scxdrdb log]# dbcli get-availableospatches
   Update Available     Reboot Required
   -------------------- --------------------
   Yes                  Yes
   [root@sxcdrdb log]

5. Use the update-server -c os -p command to run a precheck:

   dbcli update-server -c os -p

   Output:

   {
     "jobId" : "7fc5cadd-d256-436a-be0d-c2bfe9fd4e95",
     "status" : "Created",
     "message" : null,
     "reports" : [ ],
     "createTimestamp" : "March 01, 2021 07:36:19 AM UTC",
     "resourceList" : [ ],
     "description" : "OS Patching Prechecks",
     "updatedTime" : "March 01, 2021 07:36:20 AM UTC",
     "percentageProgress" : "0%"
   }

6. If the precheck is successful and uncovers no issues that prevent a successful update operation, you can update the operating system. If the precheck is not successful, address the issues identified by the precheck before trying to update the operating system.
7. To update the operating system, use the dbcli update-server -c os command:

8. [root@sxcdrdb ~]#dbcli update-server -c os

   Output:

   {
     "jobId" : "bee1c6d9-45fb-4e5b-8ee8-f02e7cd192ab",
     "status" : "Created",
     "message" : null,
     "reports" : [ ],
     "createTimestamp" : "March 01, 2021 07:37:43 AM UTC",
     "resourceList" : [ ],
     "description" : "OS Patching",
     "updatedTime" : "March 01, 2021 07:37:43 AM UTC",
     "percentageProgress" : "0%"
    }

9. [root@sxcdrdb ~]# dbcli describe-job -i 128808c-15b5-4c51-ab3a-38efc5a647c1
   
   Job details
   ----------------------------------------------------------------
                        ID:  1282808c-15b5-4c51-ab3a-38efc5a647c1
               Description:  OS Patching
                    Status:  Success
                   Created:  April 5, 2023 4:06:16 PM UTC
                  Progress:  100%
                   Message:
                Error Code:
   
   Task Name                                                                Start Time                          End Time                            Status
   ------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
   
   [root@swcdrdb ~]#

10. If the operating system update requires a reboot, reboot the server after the update operation is complete.