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.

Configuration

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.

Be sure to clean any remaining files:

Configuration Files

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

Manager

Extract job: EBKEXT1

DUMP job: EBKDMP1

cat /u01/app/oracle/product/12.1.2/<instance name>/dirprm/ebkdmp1.prm

Add the job to the configuration

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

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

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