GoldenGate

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

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

GoldenGate Trail Purge Task Fails with “OGG-12111: JSON element ‘/csn’ does not match any schemas”

Since the beginning of the year, I had the opportunity to upgrade many GoldenGate setups to 26ai. On two of them, I was facing an issue regarding purge tasks that I could not solve. Since it took quite some(…)

LOB Replication With GoldenGate and Importance of Primary Keys

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I(…)

GoldenGate Row Identification: Misconceptions and Solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)

GoldenGate NGINX Reverse Proxy Behavior Changes

I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate. It reminded me that there is an overlooked aspect of the reverse proxy configuration, which is important when trying(…)

GoldenGate 26ai out-of-place patching with the web UI

For some customers, the end of support for GoldenGate 19c in May this year and the migration to Microservices Architecture mean that they have to adapt their patching procedures (if they had any !). Let’s(…)

GoldenGate: Regenerate NGINX Reverse Proxy After Deployment Changes

Configuring an NGINX reverse proxy for GoldenGate is well documented by Oracle, but what is not is the implication of adding or removing deployments. In fact, when modifying your GoldenGate deployments, you will have to(…)

OGG-08502 Path not found error from OGG Receiver Service

Update: this bug seems to be corrected with the latest GoldenGate patch (23.26.2.0.1). If you face this error, try to patch your GoldenGate deployments. Recently, after a successful migration to GoldenGate 26ai, a customer complained that he was(…)