How To: Configure Oracle Instant Client

Oracle Instant Client is packaged with Datical 6 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:

[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
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

Windows Instructions

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

C:\Users\Administrator\DaticalDB\instantclient>sqlplus -v
1. You should see eg. SQL*Plus: Release 12.1.0.2.0 Production