Error: Could Not Check if Multitenant Is Enabled: ORA-00942: Table or View Does Not Exist

Issue

Setup tests fail. The following error appears:

Could not check if multitenant is enabled: ORA-00942: table or view does not exist.

Environment

Connector: Oracle

Resolution

To resolve this issue, grant the Fivetran user permission to query the SYS.V_$DATABASE view.

For standalone databases, use the following command:

GRANT SELECT ON SYS.V_$DATABASE TO ;`

For multitenant container databases, use the following commands:

ALTER SESSION SET CONTAINER=CDB$ROOT;

GRANT SELECT ON SYS.V_$DATABASE TO <username> CONTAINER=<PDB_NAME>;

Cause

This issue occurs when the Fivetran user doesn't have SELECT permission on the SYS.V_$DATABASE view, which we query to determine whether the database is a multitenant container database.