Monday, March 10, 2025

How to Identify Root Cause of OCI DCBS Patch Operation Failure

 

Patching of Oracle database is now easy with the use of the OCI console.

In the OCI Console, you can identify a failed update operation by checking the update history of a DB system or individual database. If an update fails, its status will be marked as 'Failed,' along with a brief description of the error. If the error message doesn't provide sufficient information to resolve the issue, you can use the database CLI and log files to gather additional details.

$ cd /opt/oracle/dcs/bin

Use the below command to list the patching jobs on the DBCS VM. 

$ dbcli list-jobs

With the unique ID from the list of patching jobs, use the describe-job command to view more details of the job ID.

$ dbcli describe-job -i 890f9340-b6da-4b72-9c29-bd3a99bcc379  -j 


The output will show details of the job ID including error message is available. 

The logs are found on /opt/oracle/dcs/log location. 

$ cd /opt/oracle/dcs/log

Steps to Deploy a 4-Node MySQL 8.4 InnoDB Cluster

      Introduction MySQL InnoDB Cluster provides native, highly available, and fault-tolerant database services. It packages three compone...