GoldenGate on Oracle

This demo shows the integration between Oracle GoldenGate and Oracle Coherence. A new Oracle GoldenGate Adapter enables two-way synchronization between the Coherence cache and the Oracle database backing the cache. Data stored in the cache through Java APIs is checkpointed to the underlying Oracle table. Conversely, data stored directly into the Oracle table is automatically propagated to the Coherence cache.

This tutorial covers samples of tools and scripts used to automate tasks in Oracle GoldenGate. The two ways to do this are to control everything from inside of GGSCI using Obey files, and to control everything from outside of GGSCI using shell scripts such as bash.

This tutorial provides instructions on how to configure Oracle GoldenGate to take DML transactions from an Oracle database and send them to an Oracle WebLogic Server (WLS) JMS queue using GoldenGate Java Adapters.

Upon completion of this Oracle-By-Example (OBE) tutorial, you will be able to keep two heterogeneous databases synchronized using Oracle GoldenGate (OGG); in this case a Linux Oracle 11gR2 database to an Exadata 11gR2 database. This OBE presumes you already know how to use OGG for single-node 11g-to-11g replication.

Step-by-step instructions on installing, configuring, and managing Oracle GoldenGate version 11.2.1.0.2 on a pair of Linux Oracle 11gR2 databases. Bidirectional replication will be configured on sample tables.

This OBE covers installing, configuring and activating asynchronous replication between an Oracle (RDBMS  11gr2) database  and an IBM DB2 9.7 database.

In the first part of the OBE, the data flow goes from Oracle to DB2. In the second part, data is replicated from DB2 to Oracle, thus covering all aspects of heterogeneous replication between Oracle and DB2.

Step-by-step instructions on installing, configuring, and managing Oracle GoldenGate version 11.2.1.0.2 on a pair of Linux hosts: the source is MySQL 5.5 and the target is Oracle 11gR2 database. Unidirectional replication will be configured on sample tables.

This Oracle-By-Example (OBE) tutorial covers installing, configuring, and running the Oracle GoldenGate HotCache Adapter for Oracle Coherence. The Oracle GoldenGate HotCache Adapter for Coherence provides a mechanism to synchronize changes made directly to an Oracle database with a Coherence cache. Such synchronization is two-way: all changes made to data residing in the Coherence cache are checkpointed to the Oracle database, and all changes made to the Oracle database are propagated to the Coherence cache. 

This tutorial provides instructions on how to configure GoldenGate to provide Audited NonStop Enscribe to Oracle synchronization using a data pump for change data capture.

This OBE tutorial provides instructions on how to configure GoldenGate to provide Audited NonStop SQL/MP to Oracle 11g synchronization. The initial data load is done with SQL*Loader, and a data pump is used for change data capture.

This tutorial provides instructions on how to configure GoldenGate to provide Non-Audited NonStop Enscribe to Oracle synchronization.

This tutorial provides instructions on how to configure GoldenGate to provide HP NonStop SQL/MX to Oracle synchronization.