GoldenGate

ORACLE GOLDEN GATE INSTALLATION IN 19c DATABASE

Environment Details Server Name                         : primegg.localdomain OS Version                           : Oracle Linux Server release 7 Database Version                 : 19.0.0.0 GoldenGate Version             : 19.1.0.0.4 for oracle Oracle Home                        : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…

Read More

Oracle GoldenGate 19c Silent Installlation

Introduction Usually to install database software we will use ./runInstaller graphical user interface. Some times we may not have access to a graphical user interface. Silent mode installation allows to…

Read More

GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904

Issue : GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904 Observation : *** ACTION NAME:(OGG$RNDDEV_A – Apply Server) 2016-06-01 15:50:47.102 dbkedDefDump(): Starting a non-incident diagnostic dump…

Read More

Oracle GoldenGate upgrade 19c

A. Pre-Upgrade Tasks 1. Download the latest OGG software from support.oracle.com. In our demo we have downloaded Oracle_GoldenGate_19.1.0.0.4.zip for Linux 64 bit. 2. Copy the OGG software to the source…

Read More

Handy commands for “REPLICAT” Process in Oracle GoldenGate

Introduction: The Goldengate Replicat process is also known as the apply process. It is a mandatory process in the Goldengate setup. This data delivery process is the last component to…

Read More

Important commands in Goldengate related to “EXTRACT” Process

  Introduction : The Oracle Goldengate Extract process captures transactions that have been committed from the Oracle Redo Logs or Archived Logs. The Extract process writes the captured source data…

Read More

Frequently used “MANAGER” related commands in Oracle GoldenGate

Introduction : The Goldengate Manager is the first process that needs to be setup in the replication configuration. This process must be running on the source and the target system.…

Read More