Oracle

Migrate your database to 26ai on ODA

Introduction Oracle 26ai is not yet available on Bare Metal ODA, but it will probably be in a few weeks. For now, 26ai is available as a DB System on Oracle Database Appliance, meaning that it’s already possible to(…)

Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai

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

Planning GoldenGate 23ai migration before support expires

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

Exascale storage architecture

In the first article, we discovered Exascale from a high level overview with a focus on Exascale Infrastructure. In this new article, we will dive into the Exascale storage architecture, with details about the physical components as well as the(…)

OGG-10556 when starting extract from GoldenGate 23ai web UI

Another day, another not-so-documented GoldenGate error, this time about the OGG-10556 error, which I had when setting up replication on a new GoldenGate installation. After making changes from the web UI in an extract, I ended with the following(…)

How to patch your ODA to 19.29?

How to patch your Oracle Database Appliance to 19.29(…)

Extend session timeout in GoldenGate Microservices Web UI

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways(…)

Shell and Perl in one script

To run a Perl script directly like a binary from within the shell, you have to set the executable flag on the script Add the shebang line (the 1st line (#!...) specifiyng the interpreter to use) #!/usr/bin/env perl(…)

Oracle to PostgreSQL Migration with Flink CDC

Introduction When wanting to migrate from the big red to PostgreSQL, most of the time you can afford the downtime of the export/import process and starting from something fresh. It is simple and reliable. Ora2pg being one of the(…)

Exascale Infrastructure : new flavor of Exadata Database Service

Oracle unveiled Exadata Database Service on Exascale Infrastructure in summer 2024. In this blog post, the first of a series dedicated to Exascale, we will dive into its architecture after a brief presentation of what Exascale is. Introduction Exadata(…)