Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Jérôme Witt

DOAG 2018 – Fazit: it’s not only about Oracle anymore

By | Database Administration & Monitoring | No Comments

Amazing conference, amazing people and awesome party like every year  and of course great networking like every year This year, I was quite impressed about the number of different technologies. Speeches were not only centered around the big red O. As already summarized, by my colleague Alain yesterday: DOAG 2018 – Not only database – Docker and Kubernetes rule the world Open Source RDBMS, containers and microservices are arising much more quickly than cloud computing…

Read More
Alain Lacour

DOAG 2018 – Not only database – Docker and Kubernetes rule the world

By | Database Administration & Monitoring | No Comments

The DOAG Konferenz is about everything around the Oracle database and Oracle technologies. But this year, as stated in the blog of Daniel Westermann more and more open source as well as “hype” subjects from which Docker and Kubernetes are very popular. Looking at the program we can see about 20 presentations on those 2 technologies: DevOps mit der Oracle Datenbank Oracle, PostgreSQL, Docker und Kubernetes bei der Mobiliar Docker und die Oracle Fusion Middleware…

Read More
Hervé Schweitzer

Funny session Oracle vs PostgreSQL battle at the #DOAG2018

By | Database Administration & Monitoring | No Comments

As each year dbi services is present at the DOAG with a nice booth and with many presentations. Today my colleague Daniel Westermann had a very funny session with Jan Karremans “Oracle vs PostgreSQL” battle. The rule of who will defend which technology was not defined before and without surprise Daniel won the Oracle Technology. But Daniel since the last year is convinced from the PostgreSQL technology. Daniel started the Battle with aggressive question to…

Read More
Daniel Westermann

DOAG 2018, more and more open source

By | Database Administration & Monitoring | No Comments

We speak about the increasing interest in open source technologies since several years and now, in 2018, you even feel that at the DOAG. There are sessions about PostgreSQL, MariaDB, Docker, Kubernetes and much more. As usual we had to do our hard preparation work before the conference opened to the public and prepare our booth and Michael almost came to his limits (and maybe he was not even sure on what he was doing…

Read More
David Barbarin

Is there too much memory for my SQL Server instance?

By | Database Administration & Monitoring, SQL Server | 2 Comments

Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting. But what about of the opposite? This question raised in a context of an environment…

Read More
Michael Hein

Patching a virtualized ODA to patch 12.2.1.4.0

By | Database Administration & Monitoring | No Comments

This article describes patching a virtualized Oracle Database Appliance (ODA) containing only an ODA_BASE virtual machine. Do this patching first on test machines because it can not be guaranteed that all causes of failures of single VM ODAs are covered in this article. I got the experience that precheck for ODA patches does not detect some failure conditions which may lead to an unusuable ODA. Overview: Patch first to 12.1.2.12.0 After that patch to 12.2.1.4.0…

Read More
Julia Gugel

DC/OS: Install Marathon-LB with keepalived

By | Database Administration & Monitoring | No Comments

After the minimal setup of the DC/OS in my further articles, I wanted to extend my DC/OS and add a loadbalancer. There are two options for loadbalancing in DC/OS 1. Marathon-LB (a layer 7 load balancer, used for external requests, based on HAProxy) 2. Named VIPs (a layer 4 load balancer used for internal TCP traffic) In this article we will use Marathon-LB. In case you want to read more about the VIP solution, just…

Read More
Daniel Westermann

EDB BART 2.2, parallel full backups without using pg_basebackup

By | Database Administration & Monitoring | No Comments

Some days ago EnterpriseDB released the latest version of its backup and recovery tool for PostgreSQL and EDB Postgres Advanced Server, release notes here. The main new features, at least for me, are backups using multiple cores and parallel incremental restores. Besides that BART does not require pg_basebackup anymore for taking full backups of a PostgreSQL instance. The downside with that could be that you can not easily restore the backups without using EDB BART….

Read More
Michael Hein

Recovering from failed patch on virtualized ODA

By | Database Administration & Monitoring | No Comments

When a patch fails on a virtualized Oracle Database Appliance (ODA), this ODA is often unusuable because Linux and OAKD are patched to new release but Grid Infrastructure is still on old version. OAKD cannot be restarted in default mode because in this mode the active Grid Infrastructure version is checked, which will fail due to old version. Also Grid Infrastructure cannot be started due to the fact that OAKD controls access of shared hardware…

Read More