Julien Delattre

The Undocumented GoldenGate ‘all’ Role You Should Know About

Let me tell you a story about how I discovered an undocumented role in GoldenGate that could break your automation. Recently, I wanted to do a massive update of the role of a GoldenGate user on multiple deployments. First of(…)

Deployment Creation INS-85037 Error With GoldenGate 26ai for DB2 z/OS

Among all the automation I was doing around a GoldenGate installation for DB2, I recently ended up with an INS-85037 error when running the configuration assistant oggca.sh. And because this error is quite common and has many different possible root(…)

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

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

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

USERID Syntax Warning in GoldenGate Migration Utility

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

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. OGG-08048: Failed to initialize timezone information. Check location of ORACLE_HOME. What should you do exactly, and how do you avoid this error in(…)

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

Creating an Oracle Cloud Infrastructure VM Using the CLI

Oracle Cloud Infrastructure (OCI) provides an easy-to-use command line interface named oci, with which you can do a lot of administrative tasks. Let’s see in this blog how to create virtual machines in OCI with this. Setting up oci-cli(…)

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