Oracle

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

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

Deployment removal failed in GoldenGate Configuration Assistant (INS-85038)

Recently, I wrote about deleting a GoldenGate deployment with the REST API, and when investigating this issue, I remembered a limitation of the configuration assistant, which I wanted to talk about. For more information about(…)