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/