Oracle GoldenGate 21c -- Configure an Oracle Database 11.2 for Data Capture

Problem

You need to configure an Oracle Database 11.2.0.4 version for data capture by Oracle GoldenGate 21c Extract

Solution

1) Oracle Database 11.2 requires extra preparation steps for successful data capture. For more information check:

• Oracle GoldenGate 21c -- Additional Prepartion of an Oracle Database 11g for Data Capture

2) Enable GoldenGate replication:

SQL> alter system set ENABLE_GOLDENGATE_REPLICATION=true scope=both sid='*';

3) Enable minimal supplemental logging:

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

4) Enable force logging:

SQL> ALTER DATABASE FORCE LOGGING;

5) Create a GoldenGate  user to be used by Extract:

SQL> create user ggadmin identified by "<password>"
     default tablespace users temporary tablespace temp;

SQL> grant connect, resource, dba to ggadmin;
SQL> alter user ggadmin quota unlimited on users;

SQL> exec dbms_goldengate_auth.grant_admin_privilege('GGADMIN' );

6) Enable replication support for sequences:

• Oracle GoldenGate 21c -- Enable Replication of Sequences for an Oracle Database

7) Ensure minimal requirement for streams_pool_size parameter:

SQL> alter system set streams_pool_size=<1GB x # of Extracts> scope=both;