Oracle 19C Golden Gate Pre-Requisites for replication Complete step by step lab

 Hi All,

in this post i am going to share about oracle golden gate post install pre-requisites for replication.

lab environment :

2 servers >> source and target server 

source golden gate server >> ggnode1 

target golden gate server >> ggnode2

note : i have installed the oracle 19c database and Oracle 19C golden gate software on both the nodes .

set the Source node environment : 

set the Target Node environment : 

In order for GoldenGate to replicate data from Source database to target database, there are some pre-requisite steps to be performed on both Source & Target Database like

>> Set Parameter Enable_GoldeGate_Replication to TRUE (on both source & target database)

>> Create Global User in Database 19c with prefix C##  (on both source & target database)

>> Grant DBA Role to this user (on both source & target database)

>> Enable Supplemental Logging (on source database)

>> Enable Database in Archive Log Mode (on source database).

Pre-requisite on Source Node :::

      Enable Goldengate Replication >>   set the environment and enable it on CDB$ROOT leave this parameter cant enable on PDB level..

If you try to enable at pdb level you can see below error :

Now CREATE GLOBAL USER & GRANT DBA ROLE 

Note Below tablespace needs to be present in both Container and pluggable. 

Make sure you are connected to first container and then Plugabble database before creating tablespace. Otherwise you will hit with an error while starting the PDB 

1. Create tablespace ggs_tblsp in both container and pluggable db's 

Connect to Container (ggdb1):

create tablespace ggs_tblsp datafile '/u01/app/oracle/oradata/GGDB1/gg.dbf' size 2G;

Connect to Pluggable (pdb1):

create tablespace ggs_tblsp datafile '/u01/app/oracle/oradata/GGDB1/pdb1/gg.dbf' size 2G;

2. Create a user in container database with prefix c##. 

Note: In 19c this user is common to all the pluggables present. (In 19c all common users and roles are created with prefix c##)

SQL> create user c##sourcegg1 identified by Welcome1 default tablespace ggs_tblsp;

SQL> grant dba to c##sourcegg1 container=all; 

SQL> exec dbms_goldengate_auth.grant_admin_privilege ('c##sourcegg1',container=>'all');

ENABLE SUPPLEMENTAL LOGGING 

Note : To Enable Supplemental Looging please make sure conneted with CDB Database

Enable supplemental Logging as 

alter database add supplemental log data (all) columns;

Import step is database should be archive log mode enable :

check if it not enable , enable it .

open database 

this concludes source side pre-requisites are completed .

Pre-requisite on Target Node :::

     Enable Goldengate Replication >>

CREATE GLOBAL USER & GRANT DBA ROLE 

Note : Below tablespace needs to be present in both Container and pluggable. 

Make sure you are connected to first container and then Plugabble database before creating tablespace. 

Otherwise you will hit with an error while starting the PDB 

1. Create tablespace ggs_tblsp in both container OGGDB2 and Pluggable PDB2

Create tablespace ggs_tblsp in both container and pluggable as

create tablespace ggs_tblsp datafile '/u01/app/oracle/oradata/GGDB2/gg.dbf' size 2G;

Connect to Pluggable (pdb2):

create tablespace ggs_tblsp datafile '/u01/app/oracle/oradata/GGDB2/pdb2/gg.dbf' size 2G;

2. Create a user in container database with prefix c##.

Note: In 19c this user is common to all the pluggables present. (In 19c all common users and roles are created with prefix c##)

create user c##sourcegg2 identified by Welcome1 default tablespace ggs_tblsp;

grant dba to c##sourcegg2 container=all; 

exec dbms_goldengate_auth.grant_admin_privilege ('c##sourcegg2',container=>'all');

we have successfully completed the Oracle 19C golden gate pre-requisites for replication on both golden gate servers.

Thanks,

Srini