Database Administration & Monitoring

Oracle Core factor and Oracle or non-Oracle Cloud

By Franck Pachot . Oracle Database licensing can be based on two metrics: Processor or Named User Plus (NUP). NUP also necessitate to count the processors because there is a minimum number of NUP per processor. Then it is very(…)

Temporal tables with PostgreSQL

By Mouhamadou Diaw In this blog we are going to talk about a nice extension in PostgreSQL: temporal_tables. This extension provides support for temporal tables. What is a temporal table? Just a table that tracks the period(…)

Part 2 – vagrant up – get your Oracle infrastructure up an running

Last week in the first part of this blog we have seen a short introduction how to setup an Oracle Infrastructure with Vagrant and Ansible. Remember(…)

Oracle 12cR2 – RMAN cold backup with TAG’s

By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I(…)

Exadata Express Cloud Service: PDB_ADMIN privileges

By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the(…)

Oracle 12cR2 – DataGuard and Backups to NFS

By William Sescu From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter from the accessible or inaccessible point of(…)

vagrant up – get your Oracle infrastructure up an running

By using Vagrant to manage your Virtual Machines and Ansible for configuration management and provisioning you can easily automate the setup of your whole test environment in a standardized way. If you have never heard about Ansible and Vagrant(…)

From PostgreSQL 9.1.8 to PostgreSQL 9.5.5 including a standby database with minimal downtime

As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one(…)

Introducing high-availability with SQL Server on Linux

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So(…)

2016 is over and it was great, 2017 will be even more exciting in the open source area

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our(…)