Oracle

LOB Replication With GoldenGate and Importance of Primary Keys

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I(…)

GoldenGate Row Identification: Misconceptions and Solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)

Temporary tablespace and ODA 19.31.

I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the “odacli update-dbhome” : # odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71 Job details ---------------------------------------------------------------- ID: 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71(…)

GoldenGate NGINX Reverse Proxy Behavior Changes

I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate. It reminded me that there is an overlooked aspect of the reverse proxy configuration, which is important when trying(…)

GoldenGate 26ai out-of-place patching with the web UI

For some customers, the end of support for GoldenGate 19c in May this year and the migration to Microservices Architecture mean that they have to adapt their patching procedures (if they had any !). Let’s(…)

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

Oracle Database 26ai Client and SQLNET.EXPIRE_TIME

We have been facing one issue at one of our customer where the Oracle Client connections remained opened for days blocking some avaloq JobNetz. We have been doing some tests and we could fortunately find a solution resolving the problem(…)

Reduce downtime when refreshing your non-production databases using Multitenant

Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback(…)

OGG-08502 Path not found error from OGG Receiver Service

Update: this bug seems to be corrected with the latest GoldenGate patch (23.26.2.0.1). If you face this error, try to patch your GoldenGate deployments. Recently, after a successful migration to GoldenGate 26ai, a customer complained that he was(…)

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