Downstream Extract Abends With ORA-01031 When Data Vault Is Enabled
Last updated on NOVEMBER 14, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
This is a downstream OGG environment:
Source : Oracle RDBMS 188.8.131.52
Downstream: Oracle RAC 184.108.40.206.0, OGG 220.127.116.11.5
When Data Vault is enabled, Extract abends with error:
ERROR OGG-02028 Failed to attach to logmining server
Error code 1031, error message: ORA-01031: insufficient privileges.
Following message is observed in alert.log :
LOGMINER: Failed to truncate system.logmnr_spill$
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms