Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris / Université Paris-Saclay.
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…
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…
In this blog, I will present the new features introduced with the latest release (2.4.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having dbi’s best practices embedded in common scripts across all the database servers of an organization. dbi services provides the DMK (Database Management Kit) to its…
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…
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…
Oracle GoldenGate REST API has been around for quite some time now, but I’ve yet to see it used in practice at customers. Every time I tried to introduce it, it was some sort of novelty. Mainly because DBAs tend to dislike automation, but also for technical reasons. Even though the REST API was introduced in GoldenGate 12c with the…
More often than not, migrating a database is not much about moving the data but about ensuring that nothing was lost in the process. In all migration projects, a DBA will have to answer the following question: “Is my target database really identical to the source ?“ This is what Oracle GoldenGate Veridata was made for, and before diving into…
Earlier this week, Oracle Database 26ai was released, but GoldenGate 26ai is also available now ! New features were added, but before diving into some of these changes in an upcoming blog post, let’s see what changed from a GoldenGate administrator perspective. Installation, setup and patching As you may know, GoldenGate 26ai is just a patch of the existing 23ai…
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. Fortunately, Oracle provides a Migration utility (patch 37274898 / KB100447 in MOS) that is designed to migrate your old Classic Architecture to a brand new Microservices Architecture in GoldenGate 23ai. As mentioned in a previous…
Classic Extracts have been deprecated in GoldenGate 19c and shouldn’t be part of your GoldenGate replications for a long time now. Yet, some customers still have them, and with GoldenGate 19c support coming to an end in a few months, it is high time you upgrade to GoldenGate 23ai. However, GoldenGate 23ai doesn’t support classic extract, and the migration utility…
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 ! I give below the official Oracle support end dates, as per 2026. GoldenGate Release Release date End of Premier Support End of Extended Support 23ai May 2024…
The latest MongoDB DMK release (2.3.1) introduces a lot of new features and important changes, which I will describe here. dbi services provides the DMK (Database Management Kit) to its customers for multiple technologies: Oracle, Postgres, MongoDB, etc. This toolkit is provided free of charge to all clients who work with dbi services on a consulting project. The DMK is…
