Automation - Apply Database Release Update patch in Oracle 19c using Ansible



Intro: In this blog I will show you how to use Ansible to automate Oracle database patching. I applied the latest oracle 19c RU patch "Database Release Update 19.21.0.0.231017" on oracle 19c database and also rollback using Ansible.

ODA pre-check report alert (Cluster Ready Services attribute STOP_DEPENDENCIES/START_DEPENDENCIES for database is incorrect)

I am planning to Patch ODA from version 19.11 to 19.15 on X8-2L.



I am not discussing the whole ODA patching here but one of issue during pre-patch report.

When I run the Pre-patch report I got below error/alert.. This is part of pre-check report.

How to re-install correct Certified version of AHF on ExaCC


I am writing this blog as I could not find how to reinstall correct supported version of AHF on ExaCC.

Recently I upgraded AHF to latest version on ExaCC, i.e. 23.8.0.0.0

Migrate on-premise Oracle (standard edition) database on Windows to OCI DBCS

Recently, I migrated on-premise standard edition Oracle database on windows platform to DBCS in OCI.

I am writing this blog to mention all the issues/challenges which I faced during this migration. I am not writing all the commands here but the procedure on how to do that.

How to monitor DBCS database FRA using custom metric in OCI

The purpose of this blog is to show you how to use custom metric, if you don't see the default metric available in OCI for any particular case or even if you see default metric but you need the metric output to work your way :)

How To Disable Automatic Database Backups Using DBAASCLI on ExaCC

  In this blog post I will show you how to disable Automatic database backups on ExaCC using dbaascli.