KNOWLEDGE BASE

Error "clntsh not found" When Connecting to Oracle


Published: 23 Feb 2018
Last Modified Date: 09 Mar 2018

Issue

After publishing an Oracle connection to Tableau Server, you may encounters this error:
 
The drivers necessary to connect to the database server '' are not properly installed on Tableau Server. Visit http://www.tableau.com/drivers to download driver setup files. 
clntsh not found 
Unable to connect to the server "[SERVER NAME]". Check that the server is running and that you have access privileges to the requested database. 

Environment

  • Tableau Server 
  • Linux
  • Oracle

Resolution

Install missing dependencies manually.
  1. On the Tableau Server machine, run the command: ldd /opt/tableau/tableau_driver/oracle/libclntsh.so.12.1 
  2. In the output, note which dependencies are not found.
  3. Manually install the missing dependencies.
  4. Verify that all dependencies are installed by running the same command from step 1. 
User-added image

Cause

Some required dependencies are missing.
Did this article resolve the issue?