Skip to main content

Posts

Showing posts from September, 2019

How to setup Goldengate

How to Setup GoldenGate environment. Scope Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The Oracle Golden Gate (OGG) processes are configured to replicate the transactional data of both the source databases back and forth to each other. This document describes the steps to be followed to configure bidirectional replication between source and target. Procedure Database version : 12.1 GoldenGate Version : 12.2 I.                    Prepare source database for replication . Step 1: SQL> SHOW PARAMETER ENABLE_GOLDENGATE_REPLICATION. If parameter value is set as “FALSE” then make it “TRUE”. SQL>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE; Step 2: Check the current Stream Pool Size SQL> SHO...