Recovering from quarterly PSU patching disaster

Applying Patching

Applying GRID ...

Reviewing the operation modes of Oracle GoldenGate BigQuery Handler

GoldenGate for Big Data 12.3.2.1.1 introduces a new target — Google BigQuery. The BigQuery handler can work in two ...

Oracle Enterprise Manager Cloud Control 13c release 3 (13.3.0.0) database template

Intro

I am currently working on a project to install Oracle Enterprise Manager Cloud Control Release 13.3 ...

Step-by-bstep monitoring Cassandra with with Prometheus and Grafana

In this blog, I’m going to give a detailed guide on how to monitor a Cassandra cluster with Prometheus and Grafana. ...

Rotating your ProxySQL log files

Recently I received several questions about rotating log files for ProxySQL, so I decided to draft it up as a blog ...

Using RDA to check Oracle Database preinstallation

Remote Diagnostic Agent (RDA) is often under-utilized. It has some very nice features such as database preinstallation ...

Troubleshooting a datapatch error in Oracle

Troubleshooting datapatch failure

As part of patching preparation, the following command was executed and ...

How do you test your Oracle database backup?

From my experience, the one area where a DBA cannot afford to make errors is in database backup. When was the last ...

Troubleshooting a GoldenGate error code

Introduction

After applying Oracle GoldenGate V12.2.0.1.170919 for Oracle Database 12c OPTIMIZER Patch for ...

Oracle parallel query hints reference - part 7: PQ_DISTRIBUTE and partitioned tables

In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE ...

Upgrading grid infrastructure from 12.1 to 12.2 in Exadata

1 Pre-requisites / preparation

Creating a custom Oracle EBS preinstall RPM for RHEL7

Oracle, by default, ships preinstall RPMs only for Oracle Linux. Preinstall RPMs make the life of a ...

How to retrieve growth history for oracle tablespaces

A customer recently asked us to identify tablespaces that most contributed to sudden space consumption on ASM. It's ...

GoldenGate: relative or absolute path for trail files?

When implementing GoldeGate solutions, something as simple as path to trail files can create havoc. What is the ...

How to create an Oracle 18c client image in Docker

In a previous blog How to use Oracle ...

EM 12c, EM 13c: delete agent and targets using emcli

Situation

It's feasible to delete agents and targets using GUI but can take a lot of work depending on ...

Log buffer #561: A carnival of the vanities for DBAs

This Log Buffer Edition covers Cloud, Oracle, and MySQL.

How to build your very own Cassandra 4.0 release

Over the last few months, I have been seeing references to Cassandra 4.0 and some of its new features. When that ...

Gathering GoldenGate deployment status

The objective of this post is to demonstrate how to gather existing GoldenGate deployment status. The rationale is ...

How to use Oracle Instant Client Docker images

There are two available, both Version 12.2. One is found on Docker Hub and the other on the Oracle Container ...

The best times to apply Oracle quarterly patches

When is the best time to apply an Oracle quarterly patch? I suppose the answer is, "It depends." As it turns ...

Log buffer #556: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

How to determine RMAN backup size

Importance

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation ...

Cloning a PDB with encrypted data in united mode - avoid ORA-00283

The purpose of this blog post is to give you some guidelines on how to avoid " ORA-00283: recovery session canceled ...