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