GoldenGate Helath Check Report Execution Fails With ORA-06519: Active Autonomous Transaction Detected And Rolled Back
(Doc ID 3031729.1)
Last updated on DECEMBER 11, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterOracle Database - Enterprise Edition - Version 19.24.0.0.0 and later
Information in this document applies to any platform.
Symptoms
You may see the Oracle GoldenGate Health Check script to fail with below error when generating it from SQL*Plus:
oerr ora 06519
06519, 00000, "active autonomous transaction detected and rolled back"
// *Cause: Before returning from an autonomous PL/SQL block, all autonomous
// transactions started within the block must be completed (either
// committed or rolled back). If not, the active autonomous
// transaction is implicitly rolled back and this error is raised.
06519, 00000, "active autonomous transaction detected and rolled back"
// *Cause: Before returning from an autonomous PL/SQL block, all autonomous
// transactions started within the block must be completed (either
// committed or rolled back). If not, the active autonomous
// transaction is implicitly rolled back and this error is raised.
Changes
Trying to generate GoldenGate Health Check report in Oracle RDBMS.
Oracle RDBMS has been upgraded from earlier releases.
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 |