Oracle

GoldenGate DB2 z/OS upgrade checklist

Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate(…)

Fixing ORA-00904 on Oracle hidden columns during SSMA data migration

SSMA fails with ORA-00904 on Oracle SET UNUSED columns. Fix it with a custom select aliasing NULL, no source DDL required.

NGINX secured distribution path with GoldenGate REST API

In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI. But GoldenGate also(…)

GoldenGate 26ai out-of-place patching with Python

I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive. Let’s do the exact same out-of-place patch of(…)

Checking long running transactions in GoldenGate

When doing complex operations with GoldenGate, checking for long running transactions is mandatory if you don’t want to miss transactions. Let’s look at two ways of retrieving such information, first with the adminclient, and then with the REST API.

DB2 SQL1598N licensing error when upgrading GoldenGate

While upgrading GoldenGate to 26ai for a DB2 z/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (CLI Driver, in short) alongside it. Since I realized that DB2 driver(…)

GoldenGate extract abending on NFS trail: OGG-02897 / OGG-01668 Input/Output Error

While working on a client’s GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production. Here is what happened and how the issue was fixed. The client’s GoldenGate(…)

Oracle: Standard Edition 2 available with 23.26.3.?

When downloading Release Update 23.26.3., I could see this: As you can see in the Product info it also has “Oracle Server – Standard Edition”. However, I haven’t found anything official yet. I tried it and could(…)

Simplified distribution path creation in GoldenGate 26.3

The 23.26.3.0.0 release update of GoldenGate 26ai (July 2026) ships a small but welcome usability change, listed in the New Enhancements section of the release notes: Bug 39415027: Generic – Simplified Distribution and Receiver Service Path Configuration(…)

Removing rpm with dnf implies removing systemd

On an Oracle Linux 8, I installed a new package and did not pay attention that dnf used an old Oracle Linux 7 repository. Trying to remove it again, I was getting following error: Error:Problem: The operation would result in(…)