Oracle Linux Odbc

Odbc Installation

Download driver | instant Client Downloads for linux

Download Instant Client Package - Basic and Instant Client Package - ODBC

unzip both zip file

cd /opt/oracle/instantclient_12_1
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so

Validate missing library

ldd /opt/oracle/instantclient_12_1/libsqora.so.12.1

Add link for missing library

cd /usr/lib/x86_64-linux-gnu
ln -s libodbcinst.so.1.0.0 libodbcinst.so.2

export LD_LIBRARY_PATH and PATH <pr> export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1:$LD_LIBRARY_PATH export PATH=/opt/oracle/instantclient_12_1:$PATH

Odbc Configuration Sample

[OracleODBC-10g]
Description = Oracle ODBC driver for Oracle 10g
Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1
FileUsage = 1
Driver Logging = 7