All articles

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

Oracle Partition and Performance of massive/concurrent Inserts

For a customer, I had to check if partitioning improves performance of massive and concurrent inserts. The goal is to execute several Inserts in parallel via dbms_parallel_execute package (my previous blog “parallelize your Oracle Insert with DBMS_PARALLEL_EXECUTE” explains how(…)

Clone Oracle 21c Home

By Mouhamadou Diaw When deploying new Oracle Home on the same server or on a new server, you may use the downloaded Oracle binaries and do an install from scratch as usual. You may then apply any patch you have(…)

Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards

By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from /u01. See this blog concerning details. If(…)

Patching an IBM Db2 instance

The next task in my journey with DB2 is to apply a patch. In the world of DB2 there are Modification Packs and Fix packs. As far as I understand it, Modifications Packs come with new features,(…)