Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
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 is supposed to set up the required objects inside the Repository, consistently crashed. 1. Environment context and IDS upgrade This…
-
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 here) which both come with support for TDE (Transparent Data Encryption). A third player is Cybertec with it’s Cybertec PostgreSQL EE distribution of PostgreSQL and this is the distribution we’re looking at in this and the…
-
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. What should you do exactly, and how do you avoid this error in the future ? In fact, this error is easy to reproduce, which also makes it easy to avoid. Usually, it happens when following the official documentation instructions for patching. They…
-
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 time, you might recall a previous blog post where I discussed a Documentum 20.2 to 23.4 upgrade and some issues…
-
How to patch your ODA to 19.30?
Introduction Patch 19.30 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The real new feature is the possibility to rollback a server component patch done by an odacli update-servercomponents. Until now, in the rare cases you would need to do a rollback, you could only rely on…
-
Reading data from PostgreSQL into Oracle
Usually the requests we get are around getting data from Oracle into PostgreSQL, but sometimes also the opposite is true and so it happened recently. Depending on the requirements, usually real time vs. delayed/one-shot, there are several options when you want to read from Oracle into PostgreSQL. One common of way of doing this is to use the foreign data…
-
Create a new GoldenGate deployment with the REST API
Is it possible to create a new GoldenGate deployment with the REST API ? This is the question I will try to answer in this blog, based on my experience with the REST API. I will dive in what is done by the oggca.sh script when adding a new deployment and see if we can replicate this with the REST…
-
Grid Clusterware 26ai 2 node RAC upgrade from 19c rolling forward
This is third part of 26ai migration blog. We will upgrade here 2 node Clusterware with ASM in 19c. We will use newest 23.26.1 GoldImages from oracle support. This tutorial showing main steps how to perform upgrade, its not procedure to upgrade your production environment, please checkout official documentation from oracle and do proper planning and prechecks before you do…
-
Creating an Oracle Cloud Infrastructure VM using the CLI
Oracle Cloud Infrastructure (OCI) provides an easy-to-use command line interface named oci, with which you can do a lot of administrative tasks. Let’s see in this blog how to create virtual machines in OCI with this. Setting up oci-cli If you are already connected to your OCI tenancy with the command line, you can skip this part. Otherwise, let’s begin.…
-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 360,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,231 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,760 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,132 reads
Trending, last 30 days
-
pgvector, a guide for DBA – Part 2: Indexes (update march 2026)
Introduction In Part 1 of this series, we covered what pgvector is, how embeddings work, and how to store them in PostgreSQL. We ended with a working similarity search — but on a sequential scan. That works fine for a demo table with 1,000 rows. It does not work for production. This post is about what comes next: indexes. Specifically,…

-
PostgreSQL 19: pg_dumpall in binary format
One of the limitation of pg_dumpall up to PostgreSQL version 18 is, that you can only dump in text mode. While pg_dump can dump in various formats (plain,custom,tar and directory) since ages. pg_dump was always limited to text mode. This will change with PostgreSQL 19 because this was committed recently. The default is still plain text but now you have…
-
PostgreSQL Anonymizer: Simple Data Masking for DBAs
Sensitive data (names, emails, phone numbers, personal identifiers…) should not be freely exposed outside production. When you refresh a production database to a test or staging environment, or when analysts need access to real-looking data, anonymization becomes critical. The PostgreSQL Anonymizer extension (often called anon) is an open‑source extension that lets you mask, fake, shuffle, or generalize data directly inside…

Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.