This is because you haven't set the ORACLE_HOME
environment variable. This should be set to the directory where you installed the Oracle client libraries. For example:
ORACLE_HOME=/home/oracle/OraHome1
Note If you're using the Instant Client, set LD_LIBRARY_PATH
instead of ORACLE_HOME
. Set LD_LIBRARY_PATH
to the directory where the Instant Client is installed. For example:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/instantclient export LD_LIBRARY_PATH
There are other environment variables that you may need to set:
# For the Easysoft Oracle ODBC driver: EASYSOFT_HOME=/usr/local/easysoft export EASYSOFT_HOME # For libclntsh.so: LD_LIBRARY_PATH=LD_LIBRARY_PATH:$ORACLE_HOME/lib export LD_LIBRARY_PATH # For libodbcinst.so: LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$EASYSOFT_HOME/unixODBC/lib export LD_LIBRARY_PATH # For isql: PATH=$PATH:$EASYSOFT_HOME/unixODBC/bin export PATH