ProxySQL Query Rules: Notes From Production

PostgreSQL Backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and ...

Use RMAN KEEP Backup To Roll Back From an Upgrade

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore ...

Using FreeRadius to Authorize Oracle Connections

Introduction This article will show how to configure the FreeRadius RADIUS server for use in authorizing Oracle ...

While Upgrading from GI 12c to 19c, +asm1(19c) Cannot Detect +asm2(12c)

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running ...

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running the upgrade on Node 1, an issue ...

The things I hate about Apache Cassandra

Intro First, let me start by saying I do not hate Cassandra. I love Cassandra. In its place, Cassandra is a powerful ...

Join, Group By, and Aggregate in Cloud Data Fusion

Good news! Cloud Data Fusion is now GA. Announced at Google Next ‘19 UK on November 21, 2019, Cloud Data Fusion is a ...

Conventions Make for Easy Automation

Installing OCI Command Line Utilities in Linux and Windows

As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the following Linux systems:

How To Downgrade Grid 19c Clusterware to 12.1

There may be many reasons for downgrading from Grid 19c to 12.1; however, the reason I am downgrading is to rerun a ...

CRS-10051: CVU found following errors with Clusterware setup

Error Statement I recently found this interesting message error in a CRS alert log from a client environment:

MariaDB Temporal Tables: Uncut & Uncensored (Part III)

(This is the third of a series of blog posts covering MariaDB Temporal Tables. The first and second in the series ...

Automatic Graceful Shutdown and Consistent Startup Method for Oracle DB on Linux

Having questions about automatic startup and shutdown is quite common when dealing with new environments or ...

Exadata's InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the 19.2.12.0.0.200317 release ...

Enable Oracle Flash Cache on Red Hat Linux

The Oracle Smart Flash Cache feature was originally introduced in the 11gR2 version of Oracle Database. It works as an ...

How to Secure Your Elastic Stack (Plus Kibana, Logstash and Beats)

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

Best practices for SQL Server instances

These are a few of the Best Practices to keep up the performance better in SQL Server Instances Configuring Windows ...

Installing Elasticsearch Using Ansible – the Quick Way!

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

SYSQL: SysAdmin Query Language

What is SYSQL? Recently Tanel Poder and I were discussing the use of Linux command pipelines for data analysis, and ...