GoldenGate - Create Global user in Multitenant Architecture

Oracle Multitenant Architecture introduced in Oracle Database 12c. Here we are going to create GoldenGate Global user in Multitenant Architecture. 

Create Global User and Grant DBA role.

We need to create Global user in Multitenant Architecture for GoldenGate replication. Its always better to create separate tablespace to segregate tablespace for GoldenGate.

We need to create tablespace in both Container and Pluggable databases.

In Container
[code] create tablespace GG_TBS datafile '/u01/app/oracle/oradata/OGG/datafile/gg_cdb.dbf' size 1M autoextend on next 1M; [/code]
In PDB
[code] alter session set container=orcl1pdb; create tablespace GG_TBS datafile '/u01/app/oracle/oradata/OGG/datafile/gg_pdb.dbf' size 1M autoextend on next 1M; [/code]

If there are multiple pluggable databases we need to create tablespace in all pluggable (PDBs) databases. 

Its important to create tablespace in all pluggable databases or containers. You will get an error if tablespace not created.

Create user in container database with prefix c##

From 12c on wards all common users and roles are created with prefix c##. This user will be present in all pluggable databases.

[code] create user c##ggadmin identified by "oracle" default tablespace GG_TBS; grant dba to c##ggadmin container=all; ./ggsci dblogin userid c##ggadmin, password oracle [/code]