Creating the initial configuration
This section describes the concept behind the configuration of GoldenGate and how to set up data replication. The configuration examples are of a basic level and are based on the Oracle Scott/Tiger schema. They do not necessarily represent a production environment. Chapter 7, Advanced Configuration provides greater detail.
You may also wish to refer to the Oracle GoldenGate Reference Guide 10.4 to support your understanding of commands and parameters.
The following steps create a simple GoldenGate unidirectional source-to-target configuration, where data is replicated from the SRC schema in the OLTP database on dbserver1, to the TGT schema in the OLAP database on dbserver2.
Creating the GoldenGate administrator
Before any configuration can take place, we need to create a GoldenGate Administrator user account on both source and target databases. This account provides access to the database tables for GoldenGate configuration and runtime operations.
Log on to...
