Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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: yum install libnsl*

        1. or: sudo apt-get install libnsl

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

...