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 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 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 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.
bash
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.
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.
Step-by-step directions on installing, configuring, and managing Oracle GoldenGate version 11.2.1.0.2 on a pair of iSeries DB/400 databases using an intermediate Linux host. Unidirectional extraction and replication will be configured on sample tables.
A collection of content which covers the using the GoldenGate HotCache adapter with Coherence
Oracle GoldenGate and Microsoft SQL Server (2005, 2008)
Oracle GoldenGate and Teradata Database
Oracle GoldenGate and IBM DB2 (zOS, iSeries)
Oracle GoldenGate and HP databases (NonStop Enscribe)
Oracle GoldenGate and Oracle Coherence