Error: Unable to Validate Archive Log Access

Issue

The following error appears:

Unable to validate archive log access. Could not execute DBMS_LOGMNR.START_LOGMNR: ORA-01031: insufficient privileges ORA-06512: at ""SYS.DBMS_LOGMNR"", line 82 ORA-06512: at line 1

Environment

• Connector: Oracle
• Update method: LogMiner

Resolution

To resolve this issue, run the following SQL statement in Oracle to grant the LOGMINING privilege to the user configured for your Fivetran connection:

GRANT LOGMINING TO <username>

Cause

This issue occurs when the Oracle user lacks the LOGMINING privilege required to start a LogMiner session.