GOLDENGATE

Upgrade from 11.2.0.3 to 19c Using GoldenGate [Cookbook]

Introduction: In this post, I’ll discuss the migration of 11.2.0.3 RAC DB on Oracle Linux 6 to 19.4 RAC on a different cluster on Oracle Enterprise Linux OEL7 using GoldenGate to guarantee zero downtime. You don’t have to be an expert in GoldenGate to get this job done, this post will provide a step by […]

360 Degree Database Server Monitoring Script For Oracle

Do you have a Linux server with a critical Oracle database running on it? Are you tired of searching google for a free script that can fully monitor that server in one go? If your answer is Yes, then this article was written for you. Bring yourself a cup of tea and read this article […]

Linux Shell Script To Monitor and Report GoldenGate Lag

This script can monitor GoldenGate lag whenever it happens based on the per-defined LAG threshold inside the script. It’s highly recommended to deploy this script on all (source & destination) replication servers in order to detect the lag on all processes (Extract, Pump, and Replicate). This script is not designed to monitor the replicated data inside […]