Database Administration & Monitoring

Patching or reimaging your ODA?

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often,(…)

EDB EPAS 12 comes with interval partitioning

While community PostgreSQL 12 is in beta quite some time now (currently in beta 3) it usually takes some time until EDB EPAS will be available on top of the next major(…)

Feedback on the EMEA Red Hat Partner Conference 2019 in Prague

A few weeks ago I attended the Red Hat EMEA Partner Conference for the first time. The Red Hat Conference took place in Prague from June 25th to 27th. If you are interested in Open Source technologies and(…)

Sparse OVM virtual disks on appliances

For some reason, you may need to sparse OVM virtual disks in an Oracle appliances. Even though that feature is present trough the OVM Manager, most of the Oracle appliances doesn’t have any OVM Manager deployed on it. Therefore(…)

Red Hat 8 Server in 9 minutes into the Google Cloud

Do you have 9 minutes to learn how to quick start with the Google Cloud? Here is a simple copy/past procedure to successfully deploy a Red Hat 8 compute server into the Cloud. Installation of the Google command client(…)

dbvisit 9: Automatic Failover

By Mouhamadou Diaw dbvisit 9 is released since a few months. And one new feature I tested is the Automatic Failover. In this blog I suppose that dbvisit 9 is already installed and that the standby database is already created.

Deploying SQL Server 2019 container on RHEL 8 with podman

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server(…)

Kubernetes – How to install a single master cluster with kubeadm?

To bootstrap a minimal K8S cluster for testing purpose, kubeadm is a very interesting tool. The goal of this blog is not to explain to you the K8S architecture or the components but only the deployment part. using kubeadm. The(…)

SQL Server 2019 availability group R/W connection redirection, routing mesh and load balancing

SQL Server 2019 availability group feature will provide secondary to primary replica read/write connection redirection. I wrote about it in a previous blog post here. It consists(…)

ORA-01000 and agent13c

Recently I received errors messages from OEM13c saying too many cursors were opened in a database: instance_throughput:ORA-01000: maximum open cursors exceeded My database had currently this open_cursors value: SQL> show parameter open_cursors NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer(…)