Oracle Linux Odbc: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== 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 Dr...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Odbc Installation == | |||
Download driver | |||
[http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html | instant Client Downloads for linux] | |||
Download Instant Client Package - Basic and Instant Client Package - ODBC | |||
unzip both zip file | |||
<pre> | |||
cd /opt/oracle/instantclient_12_1 | |||
ln -s libclntsh.so.12.1 libclntsh.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> | |||
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 | |||
</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 5: | 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