How To: Configure Oracle Instant Client

Oracle Instant Client is packaged with Datical 6.x and 7.x versions. Depending on your environment, you will need to set environment variables and install additional libraries.

Linux Instructions

After installing Datical version 6.x run the following command to verify Oracle Instant Client is configured correctly:

1. [centos@ip-172-30-3-146 instantclient]$ /opt/datical/DaticalDB/instantclient/sqlplus -v

   1. You should see eg. SQL*Plus: Release 12.1.0.2.0 Production

2. If you receive the below errors do the following:

   1. [centos@ip-172-30-3-146 instantclient]$ /opt/datical/DaticalDB/instantclient/sqlplus -v
      /opt/datical/DaticalDB/instantclient/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

      1. Set the following in the .bashrc
         export ORACLE_HOME=/opt/datical/DaticalDB/instantclient
         export LD_LIBRARY_PATH=/opt/datical/DaticalDB/instantclient
         export PATH=$PATH:$ORACLE_HOME/bin

      2. Reference: https://askubuntu.com/questions/420395/sqlplus-error-while-loading-shared-libraries-libsqlplus-so-cannot-open-shared/420417

   2. [centos@ip-172-30-3-146 instantclient]$ /opt/datical/DaticalDB/instantclient/sqlplus -v
      /opt/datical/DaticalDB/instantclient/sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

      1. Run: sudo yum install libaio

         1. or: sudo apt-get install libaio1 libaio-dev

      2. Reference: https://stackoverflow.com/questions/10619298/libaio-so-1-cannot-open-shared-object-file

   3. [centos@ip-172-30-3-146 instantclient]$ /opt/datical/DaticalDB/instantclient/sqlplus -v
      /opt/datical/DaticalDB/instantclient/sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

      1. Run: sudo yum install libsnl

         1. or: sudo apt-get install libsnl

      2. Reference: https://stackoverflow.com/questions/27717312/sqlplus-error-while-loading-shared-libraries-libsqlplus-so-cannot-open-shared

Windows Instructions

After installing Datical version 6.x/7.x, run the following command to verify Oracle Instant Client is configured correctly:

1. C:\Users\Administrator\DaticalDB\instantclient>sqlplus -v

   1. You should see eg. SQL*Plus: Release 12.1.0.2.0 Production

   2. You will want to add the instantclient directory to your Path environment variable as well