Database Administration & Monitoring

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(…)

dbi Tail ranked as the 4th best alternative !

Dear colleagues, Since the publication of the dbi Tail one year ago, lots of people downloaded, and some reporters wrote articles about it. We have got many positive feedbacks, and we would like to thank you all for your attention(…)

Dataguard Oracle 12.2 : Support for Multiple Observers

By Mouhamadou Diaw With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers(…)

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c Symptom/Analysis: Using Oracle 12c in a RAC environment, you may encounter the following errors: ORA-12801: error signaled in parallel query server P000, instance rac2.localdomain:DBRAC2 (2) ORA-12154:(…)

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)

Dealing with WSFC 2016 quarantine state and availability groups

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to(…)