MySQL high availability with ProxySQL, Consul and Orchestrator

In this post, we will explore one approach to MySQL high availability with ProxySQL, Consul and Orchestrator. This is a ...

Troubleshooting Oracle Cloud Infrastructure Automatic Backups

Background I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 ...

Using MDBUtil To Create Grid Infrastructure Management Repository Database

Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of ...

OEM 13c Monitoring Features – Part 3, Reports Based on Metric Data

This is the third in a series of blog posts covering the most important topics you should know to completely monitor ...

OEM 13c Monitoring Features - Part 2, Extended Metrics

This is the second in a series of blog posts covering the most important topics you should know to completely monitor ...

OEM 13c Monitoring Features: Part 1

This is the first in a series of blog posts covering the most important topics you should know to completely monitor ...

Why you should not uninstall Database Vault from a CDB

Important Notice Now that we are fully into database upgrades, here is an important item to be aware of: As you may ...

How to Automate Killing Inactive Sessions with Resource Manager

Problem Statement Are you manually (or via a script) killing idle sessions on your database? As a consequence, your ...

An Introduction to Chaos Engineering: Trying to Break Stuff

Some time ago there was a car ad with the slogan "Don't use it, abuse it", meaning that no matter what you do to the ...

How to Find Clusterware Configuration Details Using srvctl

At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running ...

How to use createGoldImage For Cloning in 19c

According to the Oracle Database Upgrade Guide, the traditional clone.pl script has been officially deprecated. The ...

Azure Platform and Network Infrastructure Security fundamentals

How To Fix ASM Disk Header Status from "FORMER" To "MEMBER"

I made an error when creating an Oracle ASM disk group which resulted in not being able to drop or mount the disk group ...

How To Downgrade Grid 19c Clusterware to 12.1

There may be many reasons for downgrading from Grid 19c to 12.1; however, the reason I am downgrading is to rerun a ...

Issues and workarounds for Exadata Patching

This post describes some of the most recent issues I have faced while patching an Oracle database machine (Exadata). ...

Custom fix required when using latest JDK with Oracle E-Business Suite R12.1.3

Update 11-JUN-2021: Doc ID 2353710.1 has been updated. It is recommended now to apply two patches: 10.1.3 Home Patch ...

How to fix Error: OMSPatcher finds that previous patching session is not yet completed

When planning a patch for a client's OMS, I found the following: OMSPatcher finds that previous patching session is not ...

How reliable is autoupgrade.jar analyze mode?

It sounds like you hit one of those classic Oracle "gotchas" where the tool tells you everything is fine until the ...

Live Kernel Updates Without Downtime in New RHEL 8.1, 7.7 and 7.6 Release

Most often companies scheduling downtime for patching of the Linux kernel in a production environment follow strict ...

MariaDB Temporal Tables: Uncut & Uncensored (Part III)

(This is the third of a series of blog posts covering MariaDB Temporal Tables. The first and second in the series ...

How To Resolve Database Software Install To Incorrect Location

We were recently required to install database software to /u01/app/oracle/12.2/db1. However, when using GUI to install ...

How to fix EBS weblogic admin console when not accessible after CPU patching

Background With the recent CPU patching on Oracle E-Business suite R12.2, many customers faced issues with accessible ...

Cluster Level Consistency in InnoDB Group Replication

When you have multiple database servers working together as nodes in a cluster, it’s beneficial to understand how data ...

AWS's Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

Essential administrative commands for Amazon RDS for Oracle Navigating administrative limitations in RDS We often ...

Do Not Mix Different Patch Types

I was preparing to apply a July 2019 path for a single instance database without ASM. Here are the available patch ...

How to Set Up Out Of Band Notifications in OEM 13C

So, after an abnormally quiet weekend, I was being paged: Oracle Management Services (OMS) was down! Well, this ...

How to install Vertica for test purposes

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and ...