Sharing GoldenGate directories in RAC environments

GoldenGate operates in an active/passive capacity for RAC databases. When installing GoldenGate ...

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

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

Obtaining an active-passive ProxySQL on FreeBSD

Upgrading grid infrastructure from 12.1 to 12.2 in Exadata

1 Pre-requisites / preparation

How to prepare a response file for a grid 18c silent upgrade

Due to security and complexity of the environment, the option to use Graphical User Interface (GUI) is not always ...

How to accurately measure data guard lag events

If you work with Data Guard, the lag between the primary and standby database is an informative but difficult metric to ...

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

Configuring software loadbalancer for Oracle E-Business Suite

HAProxy (high availability proxy) is a free, open source software that provides TCP & HTTP-based load balancing ...

How to build a cost-effective serverless blogging platform on GCP - Part 1

I remember when I started blogging in 2008. It was a nice learning experience, and it was rewarding, too - both the ...

How to create an Oracle 18c client image in Docker

In a previous blog How to use Oracle ...

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

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

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

An Oracle-based approach to the "taxi fare" prediction problem - episode 1

Although I haven't produced a lot of posts, those I have produced were always strictly related to the Oracle RDBMS as a ...

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