Archive

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. A common shortcut is to move them first with expdp/impdp, even before GoldenGate is set up. Everything else, the(…)

OGG-02454 Trail not found in checkpoint file when migrating a Coordinated Replicat

When migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat, every attempt failed at(…)

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. Doing this by hand is completely fine, but(…)

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. In this blog, I will explain how to rename(…)

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

Credential errors (OGG-15409) with GoldenGate Migration Utility

The GoldenGate migration utility provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture. But even after some updates, it still has a few bugs, as I explained(…)

OGG-12020 payload error in GoldenGate Migration Utility

While migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following OGG-12020 error: [ERROR] OGG-12020 - The request payload for 'POST /services/v2/config/files/ext.prm' is not defined as an object It(…)

USERID syntax warning in GoldenGate Migration Utility

When running the GoldenGate migration utility, which I presented in a previous blog post, you might encounter the following warning on USERID syntax: WARNING: USERID/PASSWORD parameter is no longer supported and(…)

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 convchk utility to relocate them before migrating to the Microservices Architecture. Oracle has the following restrictions for using the(…)