Configure unixODBC connect to Oracle 11g

1. Check unixODBC is installed.

$ odbcinst -j

unixODBC 2.2.14

DRIVERS............: /etc/odbcinst.ini

SYSTEM DATA SOURCES: /etc/odbc.ini

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /home/${UID}/.odbc.ini

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8

If not, please download from http://www.unixodbc.org

2. Install Oracle 11g

...

3. Configure the Oracle ODBC Driver

$ locate libsqora

${ORACLE_HOME}/lib/libsqora.so.11.1

$ ldd ${ORACLE_HOME}/lib/libsqora.so.11.1

ldd: warning: you do not have execution permission for `${ORACLE_HOME}/lib/libsqora.so.11.1'

        linux-vdso.so.1 =>  (0x00007fff54a3a000)

        libdl.so.2 => /lib64/libdl.so.2 (0x00007f9fb6fc7000)

        libm.so.6 => /lib64/libm.so.6 (0x00007f9fb6d42000)

        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9fb6b25000)

        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9fb690c000)

        libclntsh.so.11.1 => ${ORACLE_HOME}/lib/libclntsh.so.11.1 (0x00007f9fb42e0000)

        libodbcinst.so.1 => not found

        libc.so.6 => /lib64/libc.so.6 (0x00007f9fb3f4e000)

        /lib64/ld-linux-x86-64.so.2 (0x000000322c800000)

        libnnz11.so => ${ORACLE_HOME}/lib/libnnz11.so (0x00007f9fb3b85000)

        libaio.so.1 => /lib64/libaio.so.1 (0x00007f9fb3984000)

If there is libodbcinst.so.1 => not found, create a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2

$ cd /usr/lib64

$ sudo ln -s libodbcinst.so.2 libodbcinst.so.1

3. Configure Oracle ODBC driver

Add following section into /etc/odbcinst.ini

[Oracle11g]

Description     = Oracle ODBC driver for Oracle 11g

Driver          = ${ORACLE_HOME}/lib/libsqora.so.11.1

Setup           = /usr/lib64/liboraodbcS.so                            # this is not necessary

FileUsage       =

CPTimeout       =

CPReuse         =

Driver Logging  = 7

4. Configure Oracle User Data Source

Add following section into ~/.odbc.ini

[ORACLEORCL]

driver      = Oracle11g     #driver is defined in /etc/odbcinst.ini

server      = localhost

port        = 1521

ServerName  = ORCL     # this ID is configured in $ORACLE_HOME/network/admin/tnsnames.ora

UserID      = scott

password    = tiger

5. Verify isql can work

$ isql OracleORCL

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> select 'X' from dual;

+----+

| 'X'|

+----+

| X  |

+----+

SQLRowCount returns 4294967295

1 rows fetched

SQL>