#26ai
33 posts

How to detect a suspended GoldenGate extract
While testing
EVENTACTIONS (SUSPEND)on an extract, I noticed that nothing inINFOtells you the process is suspended.
Removing instantiation filtering from a GoldenGate replicat
In a recent blog, I explained how instantiation filtering works.
DBOPTIONS ENABLE_INSTANTIATION_FILTERINGmakes a replicat discard any record whose commit CSN is at or below a table's…
GoldenGate 26ai AutoSchema
TYPEMAP: overriding the default datatype mappingIn my blog about the new automatic schema evolution feature in GoldenGate 26ai, I was replicating the following table from Oracle to PostgreSQL: The replicat created a PostgreSQL table from an…

GoldenGate AI Service bug confirmed in the Maximum Input Characters setting
In a previous blog, I noted that there might be a bug with the
Maximum Input Characterssetting in GoldenGate 26ai AI Service. The bug was confirmed by Oracle, so let's see what it is exactly.
GoldenGate 26ai automatic schema evolution: creating missing tables during an initial load
For as long as I have used GoldenGate, an initial load had one prerequisite: the target tables must already exist. Data Pump takes care of it between two Oracle databases.

Deleting GoldenGate trail files via the REST API (
OGG-30375)When automating your GoldenGate deployments, or tearing down a test environment, handling trail files is important.

GoldenGate instantiation CSN explained
For more than ten years (GoldenGate 12.2, released in 2015), GoldenGate has provided a way of performing initial load of tables with a per-table instantiation CSN.

GoldenGate 26ai AI Service: Full setup with a free Gemini key
I sometimes get asked how the new AI Service of GoldenGate 26ai works, and the best way to show it is to see it in action.

DDL filtering in GoldenGate extract and replicat
When replicating data with GoldenGate, you often want DDL changes (table alterations, new tables, dropped indexes, etc.) to follow alongside DML.

OGG-02454Trail not found in checkpoint file when migrating a Coordinated ReplicatWhen migrating a Coordinated Replicat for a client, I faced a very specific
OGG-02454error that I wanted to share.
GoldenGate REST API Python client now on
pipIn a previous post, I shared the
OGGRestAPIPython client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way.
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.

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.

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.

DB2
SQL1598Nlicensing error when upgrading GoldenGateWhile 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.

GoldenGate extract abending on NFS trail:
OGG-02897/OGG-01668Input/Output ErrorWhile 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.

Simplified distribution path creation in GoldenGate 26.3
The
23.26.3.0.0release 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 -…
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.

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.

GoldenGate NGINX reverse proxy behavior changes
I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate.

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 !).

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.

OGG-08502 Path not found errorfrom 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.
Install and configure OEM plug-in for GoldenGate
If you are licensed for the GoldenGate Management Pack, using the Enterprise Manager plug-in for GoldenGate improves monitoring and management of your deployments.

Increase GoldenGate 26ai log retention
GoldenGate logs are a powerful source of information when debugging or analyzing your deployments. However, some of these logs have a rather low retention period in active deployments.

Bulk update of GoldenGate extract profiles
After writing blogs about Default profile updates and a bug affecting profiles in GoldenGate 26ai, I realized it would be a good idea to present a quick way to update all processes at once with the…

GoldenGate 26ai logs explained
GoldenGate logs are a powerful source of information when troubleshooting or analyzing your deployments. However, there is at least one log file per service in the Microservices Architecture.

Overcome GoldenGate 26ai bug on custom profiles
In GoldenGate, processes have a few options that can be managed to fit your needs.

Change GoldenGate Default extract profile
As part of a GoldenGate setup automation, changing the
Defaultprofile of your extracts and replicats seems like a good start if you don't want to deal with custom profiles or changing each…
OGG-12020payload error in GoldenGate Migration UtilityWhile migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following
OGG-12020error: It is a very cryptic error at first glance, but let's try to…
Production-ready GoldenGate REST client in Python
*Updated in June 2026, based on the latest version of the client.

GoldenGate REST API basics with Python
Oracle GoldenGate REST API has been around for quite some time now, but I've yet to see it used in practice at customers. Every time I tried to introduce it, it was some sort of novelty.

GoldenGate 26ai: Installation and new administration features
Earlier this week, Oracle Database 26ai was released, but GoldenGate 26ai is also available now !