KNOWLEDGE BASE

Fail to refresh the extract which connect to Oracle database through Tableau Bridge with the error "Cannot load library oci.dll"


Published: 19 Aug 2022
Last Modified Date: 19 Aug 2022

Issue

Fail to refresh the extract which connects to Oracle database through Tableau Bridge with the following error in the log.

Cannot load library from preferred location, "C:\Program Files\Tableau\Tableau Bridge\bin\oci.dll"

Environment

  • Tableau Cloud
  • Tableau Desktop 2022.2.0
  • Tableau Bridge 2022.2.0
  • Windows Server 2016
  • Oracle

Resolution

1. Verify Tableau Bridge failed to refresh the extract since Tableau Bridge is looking for the file C:\Program Files\Tableau\Tableau Bridge\bin\oci.dll which doesn't exist. Note, Tableau Desktop on the same machine is connecting to the underlying Oracle database through Oracle OCI driver.

2. Uninstall Oracle OCI driver 

3. Install the Oracle JDBC driver.  4. Change Tableau Bridge from Service Mode to Application Mode, exit Tableau Bridge, then start it again, change back to Service mode.

5, Connect Tableau Desktop to Oracle database and create the extract, publish the extract to Tableau Cloud and schedule the refresh through Tableau Bridge.
 
Did this article resolve the issue?