Recovering from quarterly PSU patching disaster

Applying Patching Applying GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.181016(Patch 28429134) for AIX (64-Bit) was a ...

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 DBSAT Discoverer feature

Oracle EBS Vision Instance on docker

Continuing my previous efforts in getting docker running on Oracle Linux in this blog post, I worked on getting Oracle ...

Oracle parallel query hints reference - part 6: USE_PARTITION_WISE_GBY

Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is "brand new," introduced in 12.2. I personally ...

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 and was ...

Troubleshooting RAC GoldenGate relocation

During Oracle RAC online patching, the GoldenGate resource must be relocated to a surviving node to maintain ...

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 failed: ...

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 time ...

Troubleshooting a GoldenGate error code

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

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 can change the data distribution method across ...

Upgrading grid infrastructure from 12.1 to 12.2 in Exadata

1 Pre-requisites / preparation 12.2 Grid Infrastructure and Database Upgrade steps for Exadata Database Machine running ...

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 DBA very easy by ...

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 correct ...

How to create an Oracle 18c client image in Docker

In a previous blog How to use Oracle instant client docker images, I described how to obtain and customize an Oracle ...

How to find unused indexes and drop them safely in MongoDB

Indexes increase read performance and allow queries to access data faster. But they also need to be updated when the ...

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 configuration ...

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 Registry. ...

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 out, we ...

How to test an Oracle database upgrade using a physical standby

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to ...

HugePages for Oracle Database in Azure Cloud

So, what's up? In case you don't know, my co-worker Gleb Otochkin has written a couple of blog entries about HugePages' ...

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

This log buffer edition covers Cloud, Oracle and MySQL.

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 for the SQL ...

How to run RHEL5/Centos5 in Google Cloud

Google Cloud instances run on top of the KVM hypervisor. In newer KVM versions, such as the one used in Google Cloud, ...

Does Oracle allocate PGA in HugePages?

The short question While preparing a presentation I am giving this year about HugePages, a colleague of mine at Pythian ...

Enable X11 forwarding after Sudo SSH session for AWS EC2 Linux instance

Challenges Working with a secure environment presents some challenges and this post will demonstrate how to overcome ...