PRKO-2002 : small things, large shadows

This short blog post is a reminder to remember the syntax.

I was just trying to bring down local listeners ...

Monitor Cassandra using Zabbix

Zabbix is an open-source based enterprise level monitoring solution that aims for monitoring distributed network ...

Orphaned disks in OVM and what to do with them

Some time ago I was doing a maintenance on an OVM and noticed that it had significant number of disks without ...

Monitoring apache Cassandra metrics with Graphite and Grafana

1. Overview

Your Xtrabackup cheat sheet

My goal in this post is to present you with examples of useful operations using xtrabackup, using options which in some ...

SharePlex replication between two instances on the same host

Several days ago I was asked a question about SharePlex and should verify behaviour before providing the answer. I ...

More fun with oracle timestamp math

Timestamp Math

ORA-30926 while using impdp over a database link

Background

The other day I was doing an import using impdp in 12.1.0.2, and received ...

Ansible and AWS automation

Overview

Improve parsing and query performance - fix Oracle's fixed object statistics

What do I mean by 'fix' the the fixed object statistics? Simply gather statistics to help the optimizer. What are ...

Encrypting sensitive data in puppet using hiera-eyaml

Puppet manifests can hold a lot of sensitive information. Sensitive information like passwords or certificates ...

Exporting custom metrics to influxdb

In the TICK stack (Telegraf, InfluxDB, Chronograf, Kapacitor) from InfluxData, ...

InnoDB flushing and Linux I/O

Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically ...

Cleaning up PID files when Oracle GRID/RAC upgrades and patches fail

Introduction:

Unfortunately is it not all that unusual for a patch or upgrade to Oracle Grid or RAC to ...

CPU utilization is not a useful metric

Once upon a time CPU utilization was quite a useful metric. Following are the output of several tools that provide CPU ...

Enabling large pages on Oracle Database 11g running on IBM AIX

For implementing Large Pages on AIX first you will need to choose large page size at OS level. On AIX you can have ...

Enabling achivelog mode in 12c RAC database

Google Cloud Dataproc in ETL pipeline - part 1 (logging)

Google Cloud Dataproc, now generally available, provides access to fully managed Hadoop and Apache Spark ...

What you should know about Docker Containers for Oracle Data Integrator

Not long ago, Oracle adopted the Docker engine as one of the accepted platforms for its products and published ...

The getMOSPatch V2 is here!

A while ago I created a Bash script called getMOSPatch.sh. Its purpose was to allow downloading Oracle ...

Changes to DBCA patch application behaviour causes PDB cloning to fail

Background

Exposing Innodb internals via system variables: part 3, I/O (table data)

Introduction

This is part three of a five part blog series to explore InnoDB internals by looking at the ...

A look at current "Infrastructure as Code" Trends

Unless you have been hiding under a rock, you have probably heard the term ...

Centralized authentication with Red Hat directory server for Linux systems

User management on Linux systems can be tedious, and when you add in more than 10 systems the chances are it is going ...

Eight ways to ensure your applications are enterprise-ready