Extract Abends With ORA-01031: Insufficient Privileges System.Logmnr_Session$
(Doc ID 2618481.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Extract is abends with following errors:
2019-11-21 15:58:04 ERROR OGG-00662 OCI Error ORA-01031: insufficient privileges (status = 1031).
And following errors are reported in activity logging trace:
2019-11-21 22:22:11.408 DEBUG|ocicpp.stmt |main| 216 ocicpp/OCIStatement.cpp | Failed to execute dpi stmt
2019-11-21 22:22:11.408 DEBUG|ocicpp.err |main| 114 ocicpp/OCIErrorHandler.c | DPI Error ORA - 1031 - ORA-01031: insufficient privileges
2019-11-21 22:22:11.408 WARN |ggdb.ora.ixoci |main| 3860 ggdbora/ixoci.c | Error executing sql statement SELECT redo_compat FROM system.logmnr_session$ WHERE session# = :1 : (1031,ORA-01031: insufficient privileges
Changes
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 |