Error when trying to create an Oracle Connection

When setting up your first Oracle connection you might run into an error that looks like this:

"libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help

This error indicates that you haven’t downloaded the Oracle client/driver. This driver doesn’t ship with Arcadia and must be downloaded separately. To get your Oracle connection working, you can follow the steps below.

NOTE: Also cross reference our public documentation on this subject here.

Step 1: Obtain the Oracle Instant Client RPM from the following URL: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

  • For Oracle 11 g , use oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
  • For Oracle 12 c , use oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Step 2: Once you’ve downloaded the appropriate Oracle Instant client RPM that aligns to your version of Oracle server, copy/scp the RPM to the node or server running Arcadia Visualization Server, and then install the RPM:

sudo yum install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

Step 3: If this is the only version of Oracle Instant client installed, you can permanently add it to the runtime link path.

sudo sh -c "echo /usr/lib/oracle/11.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf" 
sudo ldconfig

However, if you have multiple versions of Oracle Instant client running, you should set this environment variable at run time so that Arcadia is pointed at the appropriate version. This can be set in the Arcadia Enterprise Service Environment Advanced Configuration Snippet (Safety Valve) in Cloudera Manager:

NOTE: paths and directories where your Oracle libraries are stored may be slightly different from environment to environment.