Database Administration & Monitoring

Clone Oracle 21c Home

By Mouhamadou Diaw When deploying new Oracle Home on the same server or on a new server, you may use the downloaded Oracle binaries and do an install from scratch as usual. You may then apply any patch you have(…)

Patching an IBM Db2 instance

The next task in my journey with DB2 is to apply a patch. In the world of DB2 there are Modification Packs and Fix packs. As far as I understand it, Modifications Packs come with new features,(…)

Jenkins – Public cloud installation

Hi Team, Sometimes I was struggling with my VM to install and test my favorite software. Many problem can occur, VM can crash , need to install again, select the correct image computer , manage resources allocation and consumption(…)

New options for pg_basebackup in PostgreSQL 15

If, and you should, are doing base backups of your PostgreSQL instances you've probably used pg_basebackup. Another use case for pg_basebackup is to create a starting point for replicas when you are setting up streaming replication. Up(…)

Setting up IBM Db2 on Linux – root installation

In the first post about Db2 I went for the non-root installation method. While this is great if you want to get started fast and to do some tests this also comes with(…)

ODA KVM Machines : Adding a Network Interface on a Virtual Machine

By Mouhamadou Diaw In a previous blog , I was talking about virtual machines on ODA servers. Sometimes it comes that we want to add another network interface for other purpose. In this blog I(…)

Getting explain plans out of Db2

The last post about Db2 was about getting it up and running. As the issue we had to solve was about performance, getting an explain plan for the problematic statement(s) was the obvious step to do. In(…)

Migrating a CentOS 7 EC2 instance to Rocky Linux 8

Some time ago I've written about migrating a CentOS 8 machine to Red Hat 8, because CentOS 8 reached end of life last December. We did that for all CentOS 8 installations at that(…)

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)

PostgreSQL on ARM using Odroid N2/N2+

For this installation i’m using a Hardkernel Odroid N2/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on(…)