All articles

Oracle 18c clone PDB and Transparent Data Encryption

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)

Managing SQL Server sa credentials with Docker secrets on Swarm

A couple of weeks ago, I was working on a MSSQL Server docker image in a context of Hidora, a swiss cloud provider based on jelastic and for Docker-based applications. When writing(…)

Deploying PostgreSQL in MiniShift/OpenShift

The last post quickly outlined on how you can setup MiniShift for playing around with OpenShift on your workstation. In this post we'll setup PostgreSQL in MiniShift using the default PostgreSQL image that already comes with MiniShift.

Oracle Fusion Middleware Infrastructure 12.2.1.2.0 – Probable Incorrect Firewall Configuration

It was a long time that I wrote my last blog. Lots of customer activities and I had no time to write one. With the acquired knowledges, it’s time to write more blogs and share knowledge, don’t you think ?(…)

Setting up MiniShift

Currently we have many requests to support customers in running PostgreSQL in Docker containers. Some of those use redhat OpenShift as the management platform for their Docker deployments. Setting up an OpenShift cluster requires quite some resources and(…)

Can I do it with PostgreSQL? – 19 – Create user … identified by values

Puh, that last post in this series is already half a year old. Time is moving too fast :( Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL(…)

Another surprising journey in Documentum-land

The journey begins In a VM Oracle VirtualBox with Centos Linux 7.0, you install Documentum v7.3 and create a docbase dmtest with its schema in a database on another VM running Oracle Linux. You start the newly created docbase and successfully(…)

2018.pgconf.de, recap

Finally I am home from pgconf.de in Berlin at the beautiful Müggelsee. Beside meeting core PostreSQL people such Devrim and Bruce, Andreas and joining Jan again for great(…)

Covering indexes in Oracle, and branch size

By Franck Pachot . A covering index is an index that contains all the columns required by your query, so that you don't have to do a TABLE ACCESS BY INDEX ROWID, which is the major cost of an index(…)

MySQL – Time mismatch between system and log files

I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR(…)