OGG-08223 ERROR: One or more containers must be specified when registering Extract for a container database.

Hi,

Sometimes You can get ” OGG-08223 ERROR: One or more containers must be specified when registering Extract for a container database. ” error.

 

Details of error are as follows.

GGSCI (msdbadm01 as C##GGS_ADMIN19C@msdbadm01/CDB$ROOT) 21> REGISTER EXTRACT E01MSD DATABASE

2020-06-04 21:54:41  ERROR   OGG-08223  ERROR: One or more containers must be specified when registering Extract for a container database.

 

This error is related with Container and Pluggable database, 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 follows.

 

GGSCI (msdbadm01) 20> dblogin USERID C##GGS_ADMIN19C@MSDBA, password GoldenGate135246*
Successfully logged into database CDB$ROOT.



GGSCI (msdbadm01 as C##GGS_ADMIN19C@msdbadm01/CDB$ROOT) 22> REGISTER EXTRACT E01MSD DATABASE CONTAINER (PDB1)

2020-06-04 21:56:11 INFO OGG-02003 Extract E01MSD successfully registered with database at SCN 16665830760029.


GGSCI (msdbadm01 as C##GGS_ADMIN19C@msdbadm01/CDB$ROOT) 23>

 

This will solve the related error.

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/