#migration
14 posts

Import order matters for GoldenGate instantiation filtering
When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change.

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.
Rename a GoldenGate Extract with the REST API
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the
adminclient. I included all necessary steps to avoid missing transactions.
Rename a GoldenGate extract without missing transactions
Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions.

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.

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.

Credential errors (
OGG-15409) with GoldenGate Migration UtilityThe GoldenGate migration utility provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture.

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…
USERIDsyntax warning in GoldenGate Migration UtilityWhen running the GoldenGate migration utility, which I presented in a previous blog post, you might encounter the following warning on
USERIDsyntax: This is not really a surprise, sinceUSERID…
Relocate trail files with convchk when migrating GoldenGate to the Microservices Architecture
Depending on the location of your GoldenGate trail files, you might have to use the
convchkutility to relocate them before migrating to the Microservices Architecture.
Upgrade GoldenGate from Classic to Microservices Architecture before it's too late !
With GoldenGate 19c and 21c Premier Support coming to an end in April 2026, time is ticking for many clients with old installations of GoldenGate.

Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai
Classic Extracts have been deprecated in GoldenGate 19c and shouldn't be part of your GoldenGate replications for a long time now.

Planning GoldenGate 23ai migration before support expires
At the moment, three versions of GoldenGate are still under Premier Support, but this will very soon change, with GoldenGate 19c and 21c coming out of Premier Support in April this year !

Using Oracle API for MongoDB on OCI
If you've ever had to deal with MongoDB after years (or even decades) of working with SQL, you've probably realized that querying JSON documents can sometimes be painful, to say the least.