Oracle Database 19c -- Configure Database for GoldenGate Extract

Problem

You need to configure an Oracle Database 19c for a GoldenGate Extract 

Solution

1) At CDB$ROOT, create a common admin user for GoldenGate:

CREATE USER c##ggadmin IDENTIFIED BY "<password>"
profile <profile>
DEFAULT TABLESPACE sysaux
TEMPORARY TABLESPACE temp;

GRANT dba to c##ggadmin;
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee=>'c##ggadmin', container=>'all');

2) At a PDB, create a local admin user for GoldenGate:

ALTER SESSION SET CONTAINER=<pdb_name>;

CREATE USER ggadmin IDENTIFIED BY "<password>"
profile bpc_schema_owner_profile
default tablespace users
temporary tablespace temp;

GRANT DBA TO ggadmin;
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('ggadmin');

3) At CDB$ROOT, enable GoldenGate for the database:

alter system set ENABLE_GOLDENGATE_REPLICATION=true scope=both;

4) At CDB$ROOT, set the STREAMS_POOL_SIZE parameter based on the formula 1 EXT x 1 GB:

alter system set STREAMS_POOL_SIZE=1g scope=both sid='*';

5) Configure the logging options:

At CDB$ROOT:

ALTER DATABASE FORCE LOGGING;

At CDB$ROOT, and source PDBs:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Verify with:

SELECT SUPPLEMENTAL_LOG_DATA_MIN, FORCE_LOGGING FROM V$DATABASE;

At CDB$ROOT:

ALTER SYSTEM SWITCH LOGFILE;