Database Administration & Monitoring

Oracle – testing resource manager plans?

By Franck Pachot . I never remember that in order to use instance caging you need to set a Resource Manager Plan but don’t need to set CPU_COUNT explicitly (was it the case in previous versions?). Here is how(…)

SQL Server – PolyBase Services when listening on all IP is disabled

Introduction You will find a lot of blogs explaining how to install the PolyBase feature with a SQL Server database instance. You will also learn how to configure it and how to use it in these blogs. But I could(…)

Getting started with the Zalando Operator for PostgreSQL

In the previous posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes, Rancher, up and running, on(…)

ODA: Move a DB to ASM after migrating from 11g to 19c

Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support –(…)

Rancher on SLES 15 as a demo environment

If you followed the last posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes and Rancher,(…)

Oracle Database Appliance: ODA patch 19.10 is out

Introduction 4 months after the 19.9, here comes the 19.10 version of the Oracle Database Appliance patch. Let’s have a look at what’s new. Will my ODA supports this 19.10 patch? The 19.10 release will be the same for all(…)

Rancher, up and running, on EC2 – 2 – Three nodes

In the last post we've brought up a RKE Kubernetes cluster on a single node. While that is cool for demonstration purposes or testing, this is nothing for a real life setup. Running the control pane, the(…)

SUSE RANCHER 2.5 – Monitoring Setup

In this short blog post, I will discuss about SUSE Rancher 2.5, the latest version. In this release, the rancher-monitoring has been introduced. With this cool feature, you can quickly deploy open-source monitoring as Promotheus and Grafana for your kubernetes(…)

How to configure additional listeners on ODA

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to(…)

Be careful with prepared transactions in PostgreSQL

PostgreSQL gives you the possibility for two-phase commit. You'll might need that if you want an atomic distributed commit. If you check the PostgreSQL documentation there is a clear warning about using these kind(…)