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/