Hello Friend's,
In This post we will discuss with 2 golden gate errors ERROR OGG-02058 ERROR OGG-02060
and Solution for the errors.
so lets get started.
Error 1 : OGG-02058
GGSCI (dm01gg01.database.com as c##ggadmin@CDBSOURCE/CDB$ROOT) 14> register extract EF_SRC1 database container(PDBSOURCE)
2020-07-16 20:37:26 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.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> SELECT supplemental_log_data_min, force_logging FROM
v$database; 2
SUPPLEME FORCE_LOGGING
-------- ---------------------------------------
YES NO
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> SELECT supplemental_log_data_min, force_logging FROM v$database;
SUPPLEME FORCE_LOGGING
-------- ---------------------------------------
YES YES
=========================================================================
Error 2 : OGG-02060
GGSCI (dm01gg01.database.com as c##ggadmin@CDBSOURCE/CDB$ROOT) 15> register extract EF_SRC1 database container(PDBSOURCE)
2020-07-16 21:05:07 ERROR OGG-02060 The Oracle mining database is not configured properly to support integrated capture.
The following configuration error must be fixed: Operation not supported because enable_goldengate_replication is not set to true.
SQL> alter system set enable_goldengate_replication=true;
System altered.
ConversionConversion EmoticonEmoticon