Skip to content

Oracle 19c

Import order matters for GoldenGate instantiation filtering

When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change. A common shortcut is to move them first with expdp/impdp, even before GoldenGate is set up. Everything else, the active partitions and the non-partitioned tables, is exported once the extract is running, with PREPARECSN set. Instantiation filtering then makes the… 

OGG-02454 Trail not found in checkpoint file when migrating a Coordinated Replicat

When migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat, every attempt failed at the checkpoint conversion step with OGG-02454 Trail … not found in checkpoint file. Because the migration utility rolls back the entire migration on any hard… 

GoldenGate DB2 z/OS upgrade checklist

Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with… 

GoldenGate extract abending on NFS trail: OGG-02897 / OGG-01668 Input/Output Error

While working on a client’s GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production. Here is what happened and how the issue was fixed. The client’s GoldenGate extract was running on a dedicated server, capturing changes from an Oracle 19c source database. Trail files were written on an NFS.… 

GoldenGate: Regenerate NGINX reverse proxy after deployment changes

Configuring an NGINX reverse proxy for GoldenGate is well documented by Oracle, but what is not is the implication of adding or removing deployments. In fact, when modifying your GoldenGate deployments, you will have to reconfigure the NGINX reverse proxy. If you don’t, part of your installation will not be working anymore. This is what will happen in the web… 

Install and configure OEM plug-in for GoldenGate

If you are licensed for the GoldenGate Management Pack, using the Enterprise Manager plug-in for GoldenGate improves monitoring and management of your deployments. And after migrating to the Microservices Architecture, you should definitely update your plug-in and rediscover all targets. Let’s see how to do all that here. In this blog, I will use the latest version of the Enterprise… 

Increase GoldenGate 26ai log retention

GoldenGate logs are a powerful source of information when debugging or analyzing your deployments. However, some of these logs have a rather low retention period in active deployments. They might then not even be useful for debugging if you send them to your dbi consultants or the Oracle support for analysis. So how can you increase GoldenGate log retention ?… 

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 test this new version. Let’s try to migrate a 19c Bare Metal PDB to a 26ai DB System using 3 different… 

Easy PDB migration with ODA and DB Systems

Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you decided to use DB Systems on your ODA, you might think that migration will not be that easy. But it’s… 

Oracle TDE part II : Encrypting Data

By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests As specified before TDE will allow encryption at 2 levels -Tablespace level -Table column level TDE will encrypt your data in rest at filesystem level.… 

Migrating Non-CDB to Multitenant

By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration Source : Linux Suse in a non-multitenant architecture Target : Oracle Enterprise Linux 8 with multitenant The database version is Oracle 19c Installing Oracle Binaries…