My Oracle Support Banner

Goldengate Extract Abended with OGG-00664 OCI Error ORA (status = 1031-ORA-01031: insufficient privileges ) (Doc ID 2899818.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Goldengate Extract abends with below error:

2022-07-07 13:34:39 ERROR OGG-00664 OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
).

Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [er/redo/oracle/redooraix.c]
SourceMethod : [xoutReadLCR]
SourceLine : [16701]

2022-07-07 13:34:40 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.

Source Context :
SourceModule : [er.extract.processloop]
SourceID : [er/extract/processloop.cpp]
SourceMethod : [processExtractLoop]
SourceLine : [468]

2022-07-07 13:34:40 ERROR OGG-02171 Error reading LCR from data source. Status 510, data source type TranLogDataSource.

Changes

Extract abend immediate after applying the below patch on OGG. 
Patch 34339401: Patch for MLR 34273566: Solaris on SPARC (64-bit): Oracle 19c: OGG 19.1.0.0.220419 Microservices

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.