My Oracle Support Banner

Capture Process Abends with OGG-00524, ORA-01456 (Doc ID 2855838.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Capture process abends with OGG-00524, ORA-01456.

ggserr.log

2022-03-09T01:48:07.819+0000  ERROR   OGG-00524  Oracle GoldenGate Capture for Oracle, <Capture>.prm:  Error in DDL trigger has been detected: ERROR: DDL sequence [41460], marker sequence [41960], DDL trace log file [<ORACLE_HOME>/log/ggs_ddl_trace.log], error code -1456 error message ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction, error stack: ORA-06512: at "<GGUSER>.DDLREPLICATION", line 1291
                              ORA-06512: at "<GGUSER>.DDLREPLICATION", line 3460
                              ORA-06512: at "<GGUSER>.DDLREPLICATION", line 3395
                              ORA-06512: at "<GGUSER>.DDLREPLICATION", line 1123
                              ORA-06512: at line 987
                              . Please investigate trace log file or contact Oracle Support.
2022-03-09T01:48:07.819+0000  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, <Capture>.prm:  PROCESS ABENDING.


This symptom occurs in the following environment.
 - Oracle Database
 - DDL trigger is enabled

Changes

This symptom occurs when implicit compilation happens in read-only.

e.g)

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.