All articles

Remove grant to public in Oracle databases

CIS recommendations The Center for Internet Security publishes the “CIS Oracle database 19c Benchmark” with recommendations to enhance the security of Oracle databases. One type of recommendations is to remove grant execute to public (chapter 5.1.1.1-5.1.1.7 Public Privileges). There(…)

ECM: Low-code, high value

First, for those unfamiliar with the term, low-code is a software development approach that uses visual, drag-and-drop interfaces and pre-built components to create applications, rather than manual coding. Low-code doesn’t always have a good reputation in the IT world because(…)

OGG-12020 Payload Error in GoldenGate Migration Utility

While migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following OGG-12020 error: [ERROR] OGG-12020 - The request payload for 'POST /services/v2/config/files/ext.prm' is not defined as an object It is a(…)

MariaDB 12.3 – Binlog Inside InnoDB

MariaDB has been quite active lately, the version 11.8 was already quite a step forward and apart from the changes on LTS schedule and the EOL durations, the RC 12.3 LTS is bringing some interesting changes to binlogs, pushing even(…)

PostgreSQL 19: pg_plan_advice

In our performance tuning workshop, especially when attendees have an Oracle background, one question for sure pops up every time: How can I use optimizer hints in PostgreSQL. Up until today there are three answers to(…)

USERID Syntax Warning in GoldenGate Migration Utility

When running the GoldenGate migration utility, which I presented in an previous blog post, you might encounter the following warning on USERID syntax: WARNING: USERID/PASSWORD parameter is no longer supported and will(…)

Dctm – IDS Source 16.7.5 config.bin crash during execution

Around six months ago, I faced a confusing issue with IDS Source 16.7.5 where the “config.bin” executable always crashed when I tried to run it. The installation of IDS binaries itself completed successfully without any errors. However, the configurator, which(…)

Commercial PostgreSQL distributions with TDE (3) Cybertec PostgreSQL EE (1) Setup

In the lasts posts in this series we’ve looked at Fujitsu’s distribution of PostgreSQL (here and here) and EnterpriseDB’s distribution of PostgreSQL (here and(…)

OGG-08048 after patching GoldenGate: explanations and solutions

When patching GoldenGate Classic Architecture, you might encounter an OGG-08048 error when restarting your extracts and replicats. OGG-08048: Failed to initialize timezone information. Check location of ORACLE_HOME. What should you do exactly, and how do you avoid this error in(…)

Dctm – Upgrade from 23.4 to 25.4 fails with DM_SERVER_E_SOCKOPT

Since its release in Q4 2025, I have worked on several upgrades from 23.4 to 25.4. The first one I worked on was for a customer using our own custom Documentum images. If you have followed my posts for some(…)