Description:-
- This article is realted to patching a DBaaS service on the Oracle 18c Cloud Database.
- We are going to applying patch using dbaascli Tool.
- it is very easy day-to-day maintenance using automation and tooling
High Level Steps
- Viewing Available Patches
- Check Prerequisites.
- Apply Patch.
- Rollback Patch.
Log into your Oracle Cloud service account and navigate to the Oracle Database Cloud Service console.
Step1:-Viewing Available Patches
Step2:-Check Prerequisites
select the “Precheck” option.
- Precheck process is running…
- Precheck failed due to dbaascli Tool lower version.
- Login in to root user and check the DBaas Tool Version.
[root@dev18c ~]# rpm -qa|grep -i dbaastools
dbaastools-1.0-1+18.1.4.0.0_180123.1336.x86_64
dbaascli dbpatchm –run -list_tools
- Using the below command to upgrade the DBaascli Tool.(check the previous output last line Patchid number we need pass here)
dbaascli dbpatchm –run -toolsinst -rpmversion=18.1.4.1.0_180523.0000
- After the upgrade the DBaascli tool and rerun the Precheck menu Button
Step3:-Apply Patch
- Applying the patch using Patch menu item and start .
- Patching process is started & the database service is placed in maintenance mode.
- Checking Patch logfile from the backend.
Patch Logfile Location /var/opt/oracle/log/dbpatchm
Step4:-Successfully Applied the Patch.
$ORACLE_HOME/OPatch/opatch lsinventory | grep applied
- Check from Front-end GUI Mode
- Check from Database Level.
Reference:-
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/patch.html
Catch Me On:- Hariprasath Rajaram
LinkedIn: https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook: https://www.facebook.com/HariPrasathdba
FB Group: https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
