Oracle GoldenGate: Create Global user in Multitenant Architecture

In this post, we are going to cover creating GoldenGate Global User in Multitenant Architecture. Oracle Database 12c introduced the Multitenant Architecture for Oracle databases.  This allows for multiple pluggable databases to exist within the same container database.

If you are new to Oracle GoldenGate then check our previous posts about Oracle GoldenGate 12c Overview & Components. And GoldenGate 12c (12.3.0.1) New Features/Changes

If you want to install Goldengate 12c then go through our post here Oracle GoldenGate 12c Download & Installation and for troubleshooting go through Oracle GoldenGate 12c: Troubleshooting using LogDump Utility

1. Create Global User & Grant DBA Role

We need to create the Global user in Multitenant architecture for Goldengate replication. In order to segregate the tablespace for golden gate user, it is advisable to create a separate tablespace. The tablespace will be required in both containers as well as in all pluggable databases.

Note: gg_tblsp needs to be created in pluggable as well as container databases.

a) In container database:

SQL> create tablespace ggs_tblsp datafile ‘/u01/app/oracle/oradata/OGGDB1/datafile/gg_cdb.dbf’ size 2G;

b) In Pluggable database:

SQL> alter session set container=PDB1;

SQL> create tablespace ggs_tblsp datafile ‘/u01/app/oracle/oradata/OGGDB1/datafile/gg_pdb1.dbf’ size 2G;

Note: Same needs to be done individually in all PDBs if there are multiple Pluggable.

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

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

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

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

Note if a tablespace is not created in any of the pluggable or containers, you will hit the error tablespace doesn’t exist.  So below is the workaround:

1. Create the tablespace in all existing containers and Pluggable
2. Or create the user without defining any tablespace. However, this is not recommended in the Prod environment.

This post is from our Oracle GoldenGate 12c Administration Training, in which we cover  Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.

Next Task For You

Want to move ahead in your career and want to get a higher Earning Job?
Get 7+ Courses for DBAs & Apps DBA in a bundle program and learn from the Industry’s best Experts.