On this blog post I will write detailed steps on how to apply patches on bare metal/virtual machine DB systems and database homes by using DBCLI.
Yes, I enjoy the black screen 🙂
No, this is not the only option. You can also use Console and API’s.
This procedure is not applicable for Exadata DB systems.
1) Access to the Oracle Cloud Infrastructure Object Storage service, including connectivity to the applicable Swift endpoint for Object Storage. Oracle recommend using Service Gateway to enable this access.
2) /u01 FS with at least 15Gb of free space
3) Clusterware running
4) All DB system nodes running
Backup your database prior to the patch event.
Non Prod first
Test this patch on non prod (or test) server first
1) Update the CLI
2) Wait the job to complete
3) Check for installed and available patches
4) Display the latest patch versions available
5) Run pre check
dbcli update-server --precheck
run describe-job to check job status:
dbcli describe-job -i <jobId>
6) Update the server components. This step will patch GI.
Once successfully completed proceed with DB home patching.
7) List db homes
8) Run update home on select OH
dbcli update-dbhome -i <Id>
And check status with describe-job command:
You can find the DCS Logs at:
Under the hood dbcli relies on opatchauto so you can also check $ORACLE_HOME/cfgtoollogs/opatchauto directory for logs.
There is also a nice doc about troubleshooting in case something goes wrong.