오지지에러

[송지환]

KTEXPERTS

Python
mm
Binnary Ajay Kumar
This is Binnary Ajay Kumar having around 4+ years of experience as Oracle DBA having exposure to SQL,PL*SQL, RAC,Dataguard, RMAN,GoldenGate,MySQL DBA and Amazon Web Services. Share your knowledge. It’s a way to achieve immortality.

Follow

Share this post
Facebook
Google Plus
Tags
Container
containerdb
database
db
error
extract
gg
goldengate
ogg
oracle
oracledatabase
oracledb
OGG-08223 Error when registering Extract for a container database.
Posted on November 17, 2021 in Golden Gate
Share via:
FacebookTwitterLinkedInWhatsApp나누기
Post Views: 1,654
OGG-08223 Error when registering Extract for a container database.




Hi Experts.

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:

SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 AV1 READ WRITE NO
4 AV2 MOUNTED
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

GGSCI (Oracle.19c.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
1
2
3
GGSCI (Oracle.19c.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Source :

GGSCI (oracle.dba.com) 4> dblogin userid c##sourcegg@to_AV1,password Welcome1
Successfully logged into database AV1.
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

GGSCI> ADD EXTRACT extint, INTEGRATED TRANLOG, BEGIN NOW
EXTRACT added
1
2
GGSCI> ADD EXTRACT extint, INTEGRATED TRANLOG, BEGIN NOW
EXTRACT added
After adding extract we need to register the extract process

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.
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

GGSCI (oracle.dba.com) 14> dblogin userid c##sourcegg@to_CDB,password Welcome1
Successfully logged into database CDB$ROOT.
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)

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.
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 .



Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform



Share via:
FacebookTwitterLinkedInWhatsApp나누기
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
You might also like...
How to change remote trail file location in Oracle GoldenGate.
Replication to GCP PostgreSQL Using Oracle GoldenGate
Replication to GCP PostgreSQL Using Oracle GoldenGate
Oracle : Adding new table to existing GoldenGate Replication without downtime
Previous Post: Replication to GCP PostgreSQL Using Oracle GoldenGate
Next Post: Ask Doubts & Learn ! (Oracle Snapshot Standby Database)
Add Comment
Name (required)
Email (required)
Website (optional)
Save my name, email, and website in this browser for the next time I comment.


Achievements


KT Experts Journey….! Watch and Subscribe Our KT Experts YouTube Channel.
Video Player


00:00
02:53

Started ktexperts.com with a small hope of sharing knowledge, And today we can proudly say that ktexperts.com is being accessed from all corners of the world. Here’s a glimpse of our growth.

Follow Our Social Networking Sites
FacebookTwitterLinkedInYouTube Channel
Categories
Categories
Select Category
Recent Comments
Binnary Ajay Kumar on How to move or rename Oracle Home
Prabhu on How to move or rename Oracle Home
Krishna on Protected: How to kill Long Running Query using scripts.
krishna on Linux Basic Commands for DevOps (PART-2)
Ankit on Data Fragmentation in PostgreSQL
Ad
Recent Posts
Variables in Python December 26, 2022
Python – Datatypes December 23, 2022
PYTHON INTRODUCTION December 21, 2022
Datapump export and import from Source PDB to Target PDB December 12, 2022
Pluggable database save state December 5, 2022
Different types of creating Pluggable Database manually. November 28, 2022
CLONE ORACLE 12c PLUGGABLE DATABASE INTO ANOTHER CDB November 18, 2022
About KTEXPERTS
KT Experts is one enthusiastic knowledge-sharing platform. The platform concentrates on all Database Technologies like Oracle Database Administration(DBA), Oracle RAC, Oracle GoldenGate, MySQL, SQL Server Database Administration, Cassandra, AWS and DevOps.

This page consists of all the well-developed articles of the Technologies. This is an effort of many dedicated professionals for a better IT world.

We have received the best reviews over time and the usage of this page has been increasingly drastic. So why wait? Let’s get started!!!

Thank you

Follow Our Social Networking Sites
FacebookTwitterLinkedInYouTube Channel
Recent Posts
Variables in Python
Variables in Python
Python – Datatypes
Python – Datatypes
PYTHON INTRODUCTION
Datapump export and import f