For this setup, we make the following assumptions:
The source and target database have already been set up.
Oracle GoldenGate binaries are already installed in both sites.
The extract method used in this example will be classic capture.
Supplemental Logging is enabled at database and table level for all the objects to be replicated.
We will follow these steps to set up this replication configuration.
Perform the following steps in the source database:
Set up the GoldenGate user. Run the following command in the source database:
sqlplus sys/**** as sysdba CREATE USER GGATE_ADMIN identified by GGATE_ADMIN; GRANT CREATE SESSION, ALTER SESSION...