My Oracle Support Banner

OGG-01489 and ORA-30567 on Capture Process With DDL Replication (Doc ID 2766954.1)

Last updated on APRIL 29, 2021

Applies to:

Oracle GoldenGate - Version 12.3.0.1.4 and later
Information in this document applies to any platform.

Symptoms

Capture process is abended by OGG-01489 and ORA-30567 when DDL replication is enabled.

< examplme of error messages in ggserr.log >
2021-03-31T19:31:33.721+0900 ERROR OGG-01489 Oracle GoldenGate Capture for Oracle, <Capture>.prm: Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing log group
SQL ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */], error code [30567],
operation [ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */ (size 128)].
2021-03-31T19:31:33.725+0900 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, <Capture>.prm: PROCESS ABENDING.

 

Changes

There are multiple Capture (Extract) processes for same tables, and "DDLOPTIONS ADDTRANDATA" is enabled on Capture process. 

Cause

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
Symptoms
Changes
Cause
Solution


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