Solve “OGG-08224 Error: CONTAINER option was specified though the database does not support containers” error
Quick post to add info about the following Goldengate error:
OGG (http://localhost:9300 test1 as ogg_pdb1@CDB2) 10> REGISTER EXTRACT E_TEST1 DATABASE CONTAINER (pdb1)
2024-12-08T17:16:58Z ERROR OGG-08224 Error: CONTAINER option was specified though the database does not support containers.
This means that you are connected directly to the PDB, and not to CDB$ROOT.
To register Goldengate 21 extracts you need to connect to the Root container with a common user.
OGG (http://localhost:9300 test1 as ogg_pdb1@CDB2) 12> DBLOGIN USERIDALIAS ogg_cdb2
Successfully logged into database CDB$ROOT.
OGG (http://localhost:9300 test1 as ogg_cdb2@CDB2/CDB$ROOT) 13> REGISTER EXTRACT E_TEST1 DATABASE CONTAINER (pdb1)
2024-12-08T17:20:36Z INFO OGG-02003 Extract group E_TEST1 successfully registered with database at SCN 8039188.
Well, in the future this is not anymore true, as new version from Goldengate and DBs will work only at PDB level.