Database Administration & Monitoring

How to fix OUI-10022 error on an ODA

When manually upgrading Grid Infrastructure on an ODA according to MOS note 2379389.1 it has to be done as grid user. This can fail with OUI-10022 error which indicates that Oracle inventory is corrupt. But when trying an “opatch(…)

Password Verification Policy in MySQL 8.0.13

The new release 8.0.13 for MySQL is available since last week. Concerning security, this comes with a new feature already announced: the Password Verification Policy. Let's have a look...

SQL Server 2019 availability groups – Introduction to R/W redirection

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and(…)

Reimaging an old X3-2/X4-2 ODA

Introduction X3-2 and X4-2 ODAs are still very capable pieces of hardware in 2018. With 256GB of RAM and at least 16 cores per node, and with 18TB RAW disk capacity as a standard these appliances are far from obsolete(…)

Deep dive Postgres at the #pgconfeu conference

Today I followed many good technical sessions at the European Postgres conference. The Postgres conferences are really technical oriented, you will find no marketing sessions there and you learn a lot of things. As promised yesterday, I wrote today my(…)

Deploy DC/OS using Ansible (Part 2) – Playbooks

Finally, after all the configuration stuff is done, we can run the playbooks Create SSH Access First the SSH Access on all nodes need to be created. Therefore the access-onprem.yml is used: Be careful, I used CentOS on(…)

Deploy DC/OS using Ansible (Part 1) – Getting Started

To start into this topic I want to shortly explain some basics. Afterwards I show you how to prepare the configuration files.

Some psql features you are maybe not aware of

It is the time of The 10th Annual PostgreSQL Conference Europe, so this is the perfect time to blog about some tips and tricks around psql you'll love. psql is such a(…)

Getting in touch with shareplex

Tuesday this week I had the opportunity to get in touch with shareplex, Quest’s replication solution. This product does not rely on Oracle licenses, so can also be used with Standard Edition. It is competitor of Oracle’s GoldenGate an used(…)

Oracle OpenWorld 2018: Day 3

By Mouhamadou Diaw Today my first session was about GDPR Data Security in the GDPR Era. It was presented by Joao Nunes, IT Senior Manager, NOS Tiago Rocha, Database Administrator, “Nos Comunicaões, Sa.” Eric Lybeck, Director, PwC(…)