You need to configure Oracle Databases to enable Oracle GoldenGate replications. In general, the steps includes:
- Apply necessary patches to enable integrated capture/delivery
- Create GoldenGate user and grant necessary privileges to access the database for capture/delivery
Please refer to Oracle GoldenGate Security: User Privileges. - Enable database logging
- Enable GoldenGate replication with ENABLE_GOLDENGATE_REPLICATION
ENABLE_GOLDENGATE_REPLICATION
To enable Oracle GoldenGate replication, you need to set ENABLE_GOLDENGATE_REPLICATION to be true for on both source and target database. ENABLE_GOLDENGATE_REPLICATION controls many services that are needed by Oracle GoldenGate replication but most important services are:
To enable Oracle GoldenGate replication, you need to set ENABLE_GOLDENGATE_REPLICATION to be true for on both source and target database. ENABLE_GOLDENGATE_REPLICATION controls many services that are needed by Oracle GoldenGate replication but most important services are:
- Capture: Enable supplemental logging for redo log to container information needed by Oracle GoldenGate replication.
- Delivery: Enable suppressing triggers, handling transient duplicates and by passing referential integrity checking.