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

Issue

Connector setup tests fail with the following error:

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

Environment

Connector: Oracle

Resolution

Grant the required SELECT privilege on the SYS.V_$DATABASE view to the Fivetran user, based on your Oracle architecture.

• For standalone databases:

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

• For multitenant container databases:

  ALTER SESSION SET CONTAINER=CDB$ROOT;
  

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

  If you intend to grant access to a local user within a specific PDB, connect to that PDB and run:

  ALTER SESSION SET CONTAINER = <PDB_NAME>;
  

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

Cause

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