Using rsync to Copy GoldenGate Trails from DBFS to ACFS

It sounds like you're putting ACFS through its paces before making the big jump. Testing for IO sustainability is a ...

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 Test MySQL Server Hostname with ProxySQL Multiplexing

Overview While working on a MySQL Galera cluster with ProxySQL, I was in the process of testing traffic going to the ...

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

Harnessing the power of Jinja2 with Ansible

Configuration files management is the core component of every configuration management tool. Templates are one of 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 run DBSAT against Oracle RDS database

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS ...

How To Delete MGMTDB and MGMTLSNR Using emcli

It sounds like you’ve run into one of those classic Oracle "features" where the system is a little too helpful for its ...

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