My Oracle Support Banner

Why OGG Extract creation fails with error OGG-06606/OGG-08223 in OGG 23ai? (Doc ID 3053633.1)

Last updated on FEBRUARY 15, 2025

Applies to:

Oracle Cloud Infrastructure - GoldenGate Service - Version NA and later
Information in this document applies to any platform.

Goal

Why OGG Extract creation fails with error OGG-06606/OGG-08223 in OGG 23ai?

According to Oracle GoldenGate 23ai manual, root-level Extract is not supported.

Configure a Multitenant Container Database
Oracle GoldenGate 23ai with Oracle Database allows the implementation of pluggable databases (PDBs) for source and target. Extract is registered for a specific PDB, which is called a per-PDB Extract.
Note:Starting with Oracle GoldenGate 23ai, root-level Extract is not supported. This implies that the user privileges are assigned at the PDB level only and the c##ggadmin user is not used with Oracle GoldenGate 23ai.
https://docs.oracle.com/en/middleware/goldengate/core/23/coredoc/prepare-database-connection-system-and-parameter-settings-oracle.html#GGABB-GUID-623D9EEC-B480-4833-8DC7-AE8FBB119A6B
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.