Skip to content

GoldenGate

Real-time data replication with Oracle GoldenGate: how to configure it, keep it running, use it for migrations and connect Oracle with other databases.

Creating path connections with GoldenGate REST API

When automating your GoldenGate deployment management, you might want to create path connections with the GoldenGate REST API. This is an important aspect when connecting GoldenGate deployments with distribution paths. A first step towards this is to create a path connection on the same deployment as the distribution server where the distribution path will run. In the GoldenGate web UI,… 

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 in a previous blog post. One of them can lead to an OGG-15409 error during the migration. This error will not appear when running the… 

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: It is a very cryptic error at first glance, but let’s try to understand what happened. Where does the error come from ? The first step is to understand what is causing the issue. For this, you need to understand how the… 

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: This is not really a surprise, since USERID is an old syntax that should not be used anymore. In fact, it is not even part of the latest versions of GoldenGate. Let’s see a very basic example… 

OGG-08048 after patching GoldenGate: explanations and solutions

When patching GoldenGate Classic Architecture, you might encounter an OGG-08048 error when restarting your extracts and replicats. What should you do exactly, and how do you avoid this error in the future ? In fact, this error is easy to reproduce, which also makes it easy to avoid. Usually, it happens when following the official documentation instructions for patching. They… 

Create a new GoldenGate deployment with the REST API

Is it possible to create a new GoldenGate deployment with the REST API ? This is the question I will try to answer in this blog, based on my experience with the REST API. I will dive in what is done by the oggca.sh script when adding a new deployment and see if we can replicate this with the REST… 

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 migration utility: Absolute path names for trail files. Classic trail file MUST reside in ./dirdat (or a subdirectory within it). If the trail file reside in another directory,… 

Production-ready GoldenGate REST client in Python

Updated in June 2026, based on the latest version of the client. In this blog, I provide GoldenGate administrators with a fully working, production-ready Python client to efficiently handle GoldenGate REST API calls. From extract creation to user management, it has never been easier to manage and monitor your GoldenGate deployments ! Basic OGGRestAPI Python class In a previous blog… 

Querying GoldenGate REST API log efficiently

In this blog post, I will guide you on how to query the restapi.log file of your GoldenGate deployments more efficiently. These logs are a valuable source of information for GoldenGate administrators but are unfortunately not easy to analyze. In fact, their format is not really suited for a complex analysis. With what I present here, you could improve the… 

Save your credential store before patching GoldenGate !

I recently had an issue with the GoldenGate credential store at a customer when patching a GoldenGate 19c setup with the latest 19.30 patch. Since it is not the first time that I have encountered this problem, I figured it would be worth doing some scripting around it. So what is the problem exactly ? When patching a GoldenGate installation… 

OGG-08116 when creating a connection with GoldenGate REST API

When playing around with the GoldenGate REST API, you might have encountered the OGG-08116 error. It happens when using the Create Connection REST API call, with the following endpoint given in the GoldenGate documentation. The OGG-08116 error is defined as such in the documentation: So what is the problem exactly ? When navigating through the GoldenGate deployment’s web UI, you… 

Debugging GoldenGate Veridata agents

A crucial step after installing a Veridata server is to set up Veridata agents. And, as mentioned in a previous blog post about GoldenGate Veridata installation, Oracle didn’t bother to indicate when an agent is failing. For instance, the following agent named vdt_agent1 starts successfully: And this agent named vdt_agent2 fails to start: Zero difference in the agent.sh output, yet…