Oracle

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

Discover refreshable clone PDB with Autoupgrade

AutoUpgrade with a refreshable clone is basically “zero‑panic upgrades with a live copy of your database.”. What problem it solves Traditionally you had to schedule a maintenance window, stop everything, take a backup, upgrade, and hope nothing went wrong.

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

Remove grant to public in Oracle databases

CIS recommendations The Center for Internet Security publishes the “CIS Oracle database 19c Benchmark” with recommendations to enhance the security of Oracle databases. One type of recommendations is to remove grant execute to public (chapter 5.1.1.1-5.1.1.7 Public Privileges). There(…)

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

How to patch your ODA to 19.30?

Introduction Patch 19.30 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The real new feature is the possibility to rollback a server component patch done by an(…)

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