GoldenGate 12c setup for Oracle Container Database

Share via:

Dear Readers,

In this article, we will see GoldenGate 12c setup for Oracle Container Database.

Separate user for Extract and Replication need to be created.
User for Extract should be common user connected to Root Container in order to interact with the logmining server.
For example: C##GGADMIN@FINANCE.
REplicat User would be PDB User and a separate User will be required for each PDB
So a single Extract can supports pulling data from multiple PDBs, but a single Replicat will only support applying data to 1 PDB.
So if pulling data from multiple PDBs, multiple replicats will need to be created to apply all the data.
The dbms_goldengate_auth.grant_admin_privilege package grants the appropriate privileges for capture and apply within a multitenant container databases.
This includes the container parameter, which must be set to ALL for the extract user, as shown in the following example:

Example:

In case of Extraction:
exec dbms_goldengate_auth.grant_admin_privilege(‘C##GGADMIN’,container=>’all’)

In case of Replication:
exec dbms_goldengate_auth.grant_admin_privilege(‘C##GGADMIN’,container=>’pdb1′)

Register Extract

(unixserver1) cd /ggs
$(unixserver1) ggsci
GGSCI (unixserver1) > dblogin userid c##ggadmin, password ggadmin
Successfully logged into database CDB$ROOT.
GGSCI (unixserver1) > REGISTER EXTRACT EXTORA DATABASE CONTAINER (PDB1);

Register extract ext1 database container(dvlp);
Add extract ext1,integrated tranlog,begin now

Replicat Configuration would be same as for traditional Oracle Database

 

Thank you for giving your valuable time to read the above information.
Follow us on 
Website               www.ktexperts.com
Facebook Page KTexperts
Linkedin Page   : KT EXPERTS

Follow Me On
Linkedin :Ankush Chawla

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Add Comment