ogg 안될경우 OGG-08223 Error

[송지환]

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 .