KNOWLEDGE BASE

Error "clntsh not found" When Connecting to Oracle


Published: 23 Feb 2018
Last Modified Date: 05 Oct 2018

Issue

When loading a view connected to an Oracle database, the following error may occur:
 
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

Step 1
Ensure Oracle driver is installed. (Include hyper link)

Step 2
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

The required Oracle driver is missing, and / or some dependencies are missing.
 
Did this article resolve the issue?