OGG-08223 Error when registering Extract for a container database.

Share via:

OGG-08223 Error when registering Extract for a container database.

 

Hi Experts

In this article, we will see the OGG-08223 Error when registering Extract for a container database.

I do have a plans to setup replication between the pluggable database in different containers. When registering the extract on Source this issue triggered.

Check the databases:

On Goldengate we need to add and register GG processes. 

Login to Goldengate command line 

Source :

Extract process is to read and process Oracle redo logs in order to extract relevant changes and write these to a trail

After adding extract we need to register the extract process

OGG-08223 :

One or more containers must be specified when registering Extract for a container database.

This error is related with CDB and PDB’s, so you need to register extract on ROOT ( container database )

So login to the ROOT Container, then register extract using container and pluggable database as follow

Note : 

we need to have listener and tns connection to container database. Here to_CDB connection will be used to connect Container (CDB$ROOT).

Extract register command will be

REGISTER EXTRACT <EXTRACTNAME> DATABASE CONTAINER (PDBNAME)

Extract registered successfully with database SCN .

 

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment