BE SHARING

All articles

ORDS with TNS

02.02.2022 by Alain Lacour

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

Ansible

What is Variable Precedence in Ansible?

31.01.2022 by Olivier Spiesser

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

Database Administration & Monitoring

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

31.01.2022 by Karsten Lenz

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

Database Administration & Monitoring

PostgreSQL 15: New function to list flags associated to GUCs

31.01.2022 by Daniel Westermann

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

Control-M

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

31.01.2022 by Mamy Rasoanaivo

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

DevOps

Do you know Rancher Desktop?

25.01.2022 by Daniel Westermann

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

Database Administration & Monitoring

Oracle Partition and Performance of massive/concurrent Inserts

24.01.2022 by Lazhar Felahi

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

Database Administration & Monitoring

Clone Oracle 21c Home

24.01.2022 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 on your actually(…)

Oracle

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

21.01.2022 by Clemens Bleile

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

Database Administration & Monitoring

Patching an IBM Db2 instance

21.01.2022 by Daniel Westermann

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