Top errors in Oracle GoldenGate12c:

https://oraclexperto.blogspot.com/2018/08/top-7-errors-in-oracle-goldengate12c.html
https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/setup.htm#GIORA367
https://www.vitalsofttech.com/enable_goldengate_replication-is-not-set-to-true/

OGG (https://oggvm01:9001 DEPLOY as SRCOGGCDB@CDB/CDB$ROOT) 7> register extract ext01 DATABASE CONTAINER (PDB01)
2020-10-07T15:54:23Z 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> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 75
Next log sequence to archive 78
Current log sequence 78
SQL> SELECT supplemental_log_data_min, force_logging FROM v$database;
SUPPLEME FORCE_LOGGING
——– —————————————
NO YES
QL> alter session set container=PDB01;
SQL> SELECT supplemental_log_data_min, force_logging FROM v$database;
SUPPLEME FORCE_LOGGING
——– —————————————
NO YES

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER DATABASE FORCE LOGGING;
SQL> SELECT supplemental_log_data_min, force_logging FROM v$database;

SUPPLEME FORCE_LOGGING
——– —————————————
YES YES

OGG (https://oggvm01:9001 DEPLOY as SRCOGGCDB@CDB/CDB$ROOT) 8> register extract ext01 DATABASE CONTAINER (PDB01)
2020-10-07T16:00:31Z 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> show parameter enable_goldengate_replication
NAME TYPE VALUE
———————————— ———– ——————————
enable_goldengate_replication boolean FALSE
SQL> alter system set enable_goldengate_replication=true;

 

SQL> create user c##gg_user identified by gg_user
default tablespace goldengate
emporary tablespace temp;
SQL> alter user c##gg_user quota unlimited on goldengate;
SQL> grant create session, connect, resource to c##gg_user container=all;
SQL> grant alter any table, alter system to c##gg_user container=all;
SQL> grant set container to c##gg_user;
SQL> grant select any dictionary to c##gg_user container=all;
SQL> grant dba to c##gg_user container=all;
SQL> exec dbms_goldengate_auth.grant_admin_privilege(‘c##gg_user’,container=>’all’)
SQL> exec dbms_goldengate_auth.grant_admin_privilege(‘c##gg_user’,’capture’,container=>’all’)
SQL> exec dbms_goldengate_auth.grant_admin_privilege(‘c##gg_user’,’apply’,container=>’all’)

Leave a Reply

Your email address will not be published. Required fields are marked *