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 at half rack ...

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

Monitoring apache Cassandra metrics with Graphite and Grafana

1. Overview Despite the fact that Apache Cassandra provides a large number of metrics through the popular Metrics ...

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

More fun with oracle timestamp math

Timestamp Math Several years ago I wrote an article on Oracle date math. Amazingly, that article was still available ...

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 the following error:'ORA-30926: ...

Ansible and AWS automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using ...

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

Exporting custom metrics to influxdb

In the TICK stack (Telegraf, InfluxDB, Chronograf, Kapacitor) from InfluxData, Telegraf serves as the crucial "T"—the ...

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 fail, requiring ...

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 clusters, and ...

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 a set of ...

The getMOSPatch V2 is here!

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

Changes to DBCA patch application behaviour causes PDB cloning to fail

Background A test upgrade from 11g to 12c and conversion to a container and pluggable database recently pointed out ...

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

A look at current "Infrastructure as Code" Trends

Unless you have been hiding under a rock, you have probably heard the term “Infrastructure as a Code” thrown around. ...

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

When it comes to building database applications and solutions, developers, DBAs, engineers and architects have a lot of ...

How to recover space from already deleted files

Wait, what? Deleted files are gone, right? Well, not so if they’re currently in use, with an open file handle by an ...