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:
|
1 2 3 4 5 6 |
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 AV1 READ WRITE NO 4 AV2 MOUNTED |
On Goldengate we need to add and register GG processes.
Login to Goldengate command line
|
1 2 3 |
GGSCI (Oracle.19c.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING |
Source :
|
1 2 |
GGSCI (oracle.dba.com) 4> dblogin userid c##sourcegg@to_AV1,password Welcome1 Successfully logged into database AV1. |
Extract process is to read and process Oracle redo logs in order to extract relevant changes and write these to a trail
|
1 2 |
GGSCI> ADD EXTRACT extint, INTEGRATED TRANLOG, BEGIN NOW EXTRACT added |
After adding extract we need to register the extract process
|
1 2 3 |
GGSCI (oracle.dba.com as c##sourcegg@AVCONDB/AV1) 11> register extract EXTAV1 database 2021-11-17 07:03:03 ERROR OGG-08223 ERROR: One or more containers must be specified when registering Extract for a container database. |
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
|
1 2 |
GGSCI (oracle.dba.com) 14> dblogin userid c##sourcegg@to_CDB,password Welcome1 Successfully logged into database CDB$ROOT. |
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)
|
1 2 |
GGSCI (oracle.dba.com as c##sourcegg@AVCONDB/CDB$ROOT) 15> REGISTER EXTRACT EXTAV1 DATABASE CONTAINER (AV1) 2021-11-17 07:09:08 INFO OGG-02003 Extract EXTAV1 successfully registered with database at SCN 1730456. |
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
Loading...
