My Oracle Support Banner

Extract Abends With ORA-01031: Insufficient Privileges System.Logmnr_Session$ (Doc ID 2618481.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle GoldenGate - Version 19.1.0.0.3 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.