Oracle Linux Odbc: Difference between revisions
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 10: | Line 10: | ||
ln -s libclntsh.so.12.1 libclntsh.so | ln -s libclntsh.so.12.1 libclntsh.so | ||
ln -s libocci.so.12.1 libocci.so | ln -s libocci.so.12.1 libocci.so | ||
</pre> | |||
Validate missing library | |||
<pre> | |||
ldd /opt/oracle/instantclient_12_1/libsqora.so.12.1 | |||
</pre> | |||
Add link for missing library | |||
<pre> | |||
cd /usr/lib/x86_64-linux-gnu | |||
ln -s libodbcinst.so.1.0.0 libodbcinst.so.2 | |||
</pre> | </pre> | ||
| Line 17: | Line 28: | ||
export PATH=/opt/oracle/instantclient_12_1:$PATH | export PATH=/opt/oracle/instantclient_12_1:$PATH | ||
</pre> | </pre> | ||
== Odbc Configuration Sample == | == Odbc Configuration Sample == | ||
<pre> | |||
[OracleODBC-10g] | [OracleODBC-10g] | ||
Description = Oracle ODBC driver for Oracle 10g | Description = Oracle ODBC driver for Oracle 10g | ||
| Line 25: | Line 36: | ||
FileUsage = 1 | FileUsage = 1 | ||
Driver Logging = 7 | Driver Logging = 7 | ||
</pre> | |||
Latest revision as of 20:09, 19 June 2015
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