Sharing GoldenGate directories in RAC environments

GoldenGate operates in an active/passive capacity for RAC databases. When installing GoldenGate on a local host, ...

How to Upgrade Grid Infrastructure to 18c

Now that Oracle Grid Infrastructure (GI) 19c has been released, it is time to upgrade your GI to 18c! I am presenting ...

Troubleshooting failed database startup after GRID Out Of Place (OOP) rollback

Successful GRID Out-of-Place (OOP) Patching to 18.6 GRID Out Of Place (OOP) patching completed successfully for ...

A script for Relocating and Restoring Database Services

Due to complex requirements for service relocate and restore as part of patching, I decided to script the process.

Running new Oracle DBSAT version 2.1.0 against Autonomous Database

Recently Oracle released the newest version of the "Database Security Assessment Tool" (DBSAT 2.1.0). This version is ...

How to a recreate disk group used by CRS

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: - I ...

Troubleshooting a failure when upgrading to Oracle 18c

Upgrading Oracle Grid Infrastructure is often a smooth ride until that final configuration step hits a wall. When ...

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

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

Fix: SQL Server to PostgreSQL Linked Server Error - "Requested conversion is not supported."

A simple command that saved me

Context So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the ...

Exposing MyRocks internals via system variables: Part 5, Data Reads

(In the previous post, Part 4, we covered Compression and Bloom Filters) In this blog post, we continue on our series ...

How to troubleshoot a failure to mount DBFS

When attempting to shut down Oracle Clusterware, you might encounter the frustrating CRS-2675: Stop of 'ora.crsd' on ...

Exposing MyRocks Internals Via System Variables: Part 3, Compaction

(In the previous post, Part 2, we covered Initial Data Flushing.) In this blog post, we continue our series of ...

Exadata: How to manage OS dependencies when upgrading to 19c

Upgrading to Exadata 19c is a significant milestone, mostly because it marks the transition from Oracle Linux 6 to ...

How to mine an RMAN Log

I recently performed a Proof of Concept (POC) to compare and contrast Oracle Recovery Manager (RMAN) backup performance ...

How to use mount-dbfs.sh to resolve "Device or resource busy"

It’s always a bit of a gamble when you start playing "Process Assassin" with fuser -mv. One minute you’re trying to ...

How to run DBSAT on RAC Instances

The scope of this article is to provide a brief summary of how to run Oracle Database Security Assessment Tool (DBSAT) ...

How to install 18c Grid Infrastructure in Silent Mode on Linux 7

This blog post will show you how to install 18c Grid and upgrade to 18.6.0.0. 1. Download the 18c binairy and Apr, 2019 ...

Examining the lifecycle of tombstones in Apache Cassandra

This post is the first part of a series of blog posts regarding the lifecycle and management of tombstones. Deleting ...

How to create an Oracle Database Cloud service (OCI) using the command line

The Oracle Cloud Infrastructure, also known as the second generation cloud, offers an integrated command line utility ...