Downloading, staging, and activating the Oracle Instant Client parcel

Cloudera distribution does not contain the Oracle Instant Client parcel. You must download the Oracle Instant Client library 19.16 (both basic and SDK clients) from the Oracle website.

  1. SSH into the Hue server host as a root user.
  2. Change directory to /usr/share/oracle.
  3. Decompress the downloaded basic and SDK files as follows:
    unzip /tmp/instantclient-basiclite-linux.x64-19.16.0.0.0dbru.zip -d .
    unzip /tmp/instantclient-sdk-linux.x64-19.16.0.0.0dbru.zip -d .
  4. Set the ORACLE_HOME and LD_LIBRARY_PATH environment variables as follows:
    export ORACLE_HOME=/usr/share/oracle/instantclient;
    export LD_LIBRARY_PATH=/usr/share/oracle/instantclient:$LD_LIBRARY_PATH;