Configuration of the source

To configure the source database we have to do two things:

Ensure the database is set correctly.

Ensure the GoldenGate is set correctly.

Both need to be configured if you want the Golden Gate to work properly.

Configure Database

We have to ensure that we have enabled:

Supplemental logging

Golden Gate Replication

Force Logging

Necessary rights for the user

So let's get started:

Enable Supplemental Logging

Enable Replication

Finally, grant the necessary rights to the user:

Grant rights to user

Configure Golden Gate

In order to configure a export on the SOURCE, we should configure 3 jobs:

Manager

Extract Job ← Reads the redo

Dump Job ← Takes the information from the previous job and dump it into retail file.

Create the configuration file with the same name as you want the JOB name to be called.

Manager

Manager Config

Extract job: EBKEXT1

Extract Config

DUMP job: EBKDMP1

Data Pump Config

Add the job to the configuration

The jobs should be added to the configuration as well using the GoldenGate Software Command Interface(GGSCI)

Golden Gate Config

After the server added configuration of the schema into the configuration, we can check and start the jobs:

Golden Gate Config Check

Wait them for couple minutes, to assure that they will not end abnormally (ABEND)