OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled

Hi,

Sometimes You can get ” OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled ” error.

Details of error are as follows.

GGSCI (msdbadm01) 6> DBLOGIN USERID C##GGS_ADMIN19C@MSDBA, password GoldenGate135246*
Successfully logged into database CDB$ROOT.



GGSCI (msdbadm01 as C##GGS_ADMIN19C@MSDBA1/CDB$ROOT) 9> REGISTER EXTRACT EMSD01 DATABASE CONTAINER (MSDBA)

2020-06-04 11:22:38  ERROR   OGG-02058  The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed:  No minimum supplemental logging is enabled.

This error is related with the Supplemental log, if you run the following command, the problem will be solved.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;



Now try again, it wil be solved as follows.

GGSCI (msdbadm01 as C##GGS_ADMIN19C@msdbadm01/CDB$ROOT) 22> REGISTER EXTRACT EMSD01 DATABASE CONTAINER (MSDBA)

2020-06-04 21:56:11 INFO OGG-02003 Extract E01MSD successfully registered with database at SCN 16665830760029.


GGSCI (msdbadm01 as C##GGS_ADMIN19C@msdbadm01/CDB$ROOT) 23>

This will solve the related error.

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/