OGG Triggerless Integrated Extract Abends With Error on DDL Trigger related tables when DDL is enabled
(Doc ID 1604243.1)
Last updated on APRIL 09, 2020
Applies to:
Oracle GoldenGate - Version 12.1.2.0.0 and laterGeneric (Platform Independent)
Symptoms
On : 12.1.2.0.0 version, 1 - Oracle DB backend
When running Integrated Extract on Oracle V11.2.0.4 or higher, taking the advantage of trigger-less DDL capture. See errors below
1. ERROR
-----------------------
OME=<path>/dbhome_1.
2013-11-08 11:52:41 ERROR OGG-02636 Oracle GoldenGate Capture for Oracle, <extract_name>: The TABLE specification 'TABLE <gg_schema>.GGS_MARKER' for the source table <gg_schema>.GGS_MARKER does not include a catalog name. The database requires a catalog name.
2013-11-08 11:52:41 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, <extract_name>: PROCESS ABENDING.
2013-11-08 11:52:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (moggbrdb): info all.
2. Sometimes, the error shows
2015-01-26 15:05:32 ERROR OGG-00529 DDL Replication is enabled but table <gg_schema>.GGS_DDL_HIST is not found. Please check DDL installation in the database.
Changes
DDL trigger is not installed as DDL trigger is not required for Integrated extract when database version is 11.2.0.4. and higher
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 |
References |