All articles

Import tnsnames.ora in LDAP directory

This post gives a short intro to directory naming, shows how to import from tnsnames.ora to an LDAP directory. Finally, as an alternative, you get an example how a TNS connection string looks like in ldif file format. LDIF can(…)

How to configure Linux Server to run Oracle Database 19c on Persistent Memory

Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage(…)

How to install a specific version of MariaDB

Recently, we had to upgrade a MariaDB server from version 10.5.4 to 10.5.13. Before to do the upgrade on a production server, I wanted to test it on a personal VM. But first, I had to find how to install(…)

PostgreSQL 15: New option for NULL handling in unique constraints

Another nice feature was just committed for PostgreSQL 15: Add UNIQUE null treatment option (discussion here, commit details here). What is it about? The answer is quite easy if we do a little example(…)

ORDS with TNS

The aim of that blog is to look into Oracle REST Data Services (ORDS) DB connection with TNS. This is following some experience at a customer who wanted to move to latest version of ORDS with APEX(…)

What is Variable Precedence in Ansible?

In Ansible, definition of variable precedence is often overlooked. Despite what I wrote in my previous blog (Use Ansible like a Programming Language), Ansible is not exactly a programming language. There is a difference, especially on the(…)

Updating Password in PostgreSQL from md5 to scram-sha-256

Many installations have a history of many major PostgreSQL releases. With PostgreSQL 10 comes scram-sha-256 for hashing passwords, by installing from packages scram-sha-256 is the default setting for new installations since PostgreSQL 13. With this small blog I will(…)

PostgreSQL 15: New function to list flags associated to GUCs

As development of PostgreSQL 15 is on its way, more and more features get committed. Today we'll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you(…)

How to trigger an action in On Do Action based of a text in the Job Log output

Normally we can trigger an On Do Action based on string found in the Job Output. But we would like to do the same for a Job log, that feature doesn’t exist, but there is a way to make it(…)

Do you know Rancher Desktop?

Today I stumbled across Rancher Desktop and thought I'll give it a try. If blogged about Rancher in the past but all those blogs talked about the full blown Rancher project. Rancher Desktop brings(…)