My Oracle Support Banner

Extract Abends after DB patching: ORA-02002: error while writing to audit trail (Doc ID 2628019.1)

Last updated on FEBRUARY 02, 2020

Applies to:

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

Symptoms

User reported that after applying Oracle RDBMS patch p30133374_122010_Linux-x86-64.zip, OGG extracts started encountering below error:


2019-12-13 09:09:19 ERROR OGG-02028 Failed to attach to logmining server Error code 2002, error message: ORA-02002: error while writing
to audit trail
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 2316
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 2304
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3658
ORA-06512: at line 1.

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