Category Archives: Oracle Golden Gate

Golden Gate reconfiguration when Oracle Database is getting upgraded from 11g to 12c (#ggdbupgrade, #ggupgrade)

Scope: This blog post is specific to environments in which Golden Gate is setup already (on version 12.1.2) and if Oracle DB is getting upgraded from 11.2.0.4 to 12.1.0.2. Pre-Upgrade DB Steps: On Source: 1. Stop all DML, DDL operations … Continue reading

Posted in Oracle Golden Gate | Leave a comment

Golden Gate Performance Tips – For DML Operations

Problem Statement: Updates and Inserts (or mainly DMLs) in GG are taking long time to execute   The top few reasons for DMLs to run long are, Heavy transactions are being processed at Source DB performance may be a reason too Unique/Primary … Continue reading

Posted in Oracle Golden Gate | Leave a comment

OGG-01004, OCI Error ORA-04098: trigger ‘User.Trigger’ is invalid and failed re-validation (status = 4098)

Issue: WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, replicat_1.prm: Aborted grouped transaction on ‘<user>.<Table_name>’, Database error 4098 (OCI Error ORA-04098: trigger ‘<User>.<Trigger>’ is invalid and failed re-validation (status = 4098), SQL <DELETE FROM “<user>”.”<table_name>” WHERE “R OW_ID” = :b0>)   … Continue reading

Posted in Oracle Golden Gate | Leave a comment

Golden Gate – Identifying Current Processing Transactions

This is an informational blog post regarding Golden Gate. When I started working on GG initially, I used to wonder how to identify the transactions that are currently being processed by the Extract and Replicat Processes. Below are the commands … Continue reading

Posted in Oracle Golden Gate | Leave a comment

Identifying the Archivelog, a GoldenGate process is currently using in Oracle

With the Integrated Capture introduced from 11.2.0.4 version, Oracle GoldenGate uses LogMiner to capture the data from the Database. So, the LogMining actually will be performed by reading the archivelog files. So, it is very important to have idea on … Continue reading

Posted in Oracle Database, Oracle Golden Gate | Leave a comment

The Oracle mining database is not configured properly to support integrated capture

Error: The Oracle mining database is not configured properly to support integrated capture. The following configuration error must be fixed:  Operation not supported because enable_goldengate_replication is not set to true Possible Cause: The Database on which GG is enabled may … Continue reading

Posted in Oracle Golden Gate | Leave a comment