I was conducting regular OS patching of all the Exadata components when one of compute nodes caused imageinfo status to report a failure. Here are the steps I took to resolve the issue.   Initially, I thought the problem was…

Oracle Patching of Databases (DB) and Grid Infrastructure (GI) is a routine and recommended process for any Oracle database. It’s  no different in Oracle Cloud Infrastructure (OCI). In fact, OCI makes it even easier for DBAs to patch the required…

How you access and retrieve data is crucial to your database’s performance and resilience: the more transactional or analytical the data processing requirements for applications, the greater the likelihood of introducing inefficiencies. As these inefficiencies increase, you may need to…

I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the “tablespace allocation metric” was not being updated on OEM for a specific database. In this case, the most recent gathering was done…

Oracle Auto Service Request (ASR) is a secure, scalable, customer-installable software feature of warranty and Oracle Support Services that provides auto-case generation when common hardware component faults occur. I thought I’d share how we monitor the ASR manager process and…

If you’ve used Azure Data Factory (ADF), you’ve probably sent email alerts. But these don’t provide any clarity or customization in the message subject line or body. How do you send an email from the ADF pipeline with a custom…

Last year, SAP announced another extension to its support deadline for legacy systems, pushing it from 2025 to the end of 2027.  Despite this minor respite, however, it’s only a matter of time before businesses reliant on older systems will…

In my previous post I showed you how to use dbt to expedite data preparation tasks on Google BigQuery. This time, I’ll show you how to integrate those dbt pipelines into workflows that load, validate and transform data.    …

This is the fifth in a series of blog posts that covers setting up the load balancer for a high available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is the fifth of a…

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If you’re already aware of it, the workaround is trivial. However, when it happened to me during the testing…