[01000][unixODBC][Dr​iver Manager]Can't open lib libsq​ora.so.11.1 : file not found

Hi

assuming you have installed correctly these components:

ORACLE DB (including instance and listener)

ODBC driver

and you are facing this problem:

[root@linuxRHEL6 bin]# isql -v simple

[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1' : file not found

 

you should check the following

[root@linuxRHEL6 bin]# ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

ldd: warning: you do not have execution permission for `/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1'

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

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

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

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

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

        libclntsh.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 (0x00007f5c22833000)

        libodbcinst.so.1 => not found

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

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

        libnnz11.so => /usr/lib/oracle/11.2/client64/lib/libnnz11.so (0x00007f5c220d1000)

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

set up env variables  

[root@linuxRHEL6 lib]# export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

[root@linuxRHEL6 lib]# export ORACLE_HOME=/usr/lib/oracle/11.2/client64

[root@linuxRHEL6 ~]# export TWO_TASK=//localhost:1521/ORCL

 

Still got the same error :

[root@linuxRHEL6 ~]# isql -v simple

[01000][unixODBC][Driver Manager]Can't open lib '/was_profs_7/oracle/app/v11.2/lib/libsqora.so.11.1' : file not found

 

 

The Solution:

create ta link for libodbcinst.so

[root@linuxRHEL6 bin]# ln -s /usr/lib64/libodbcinst.so.2 /usr/lib64/libodbcinst.so.1

 

[root@linuxRHEL6 bin]# isql -v

[IM010][unixODBC][Driver Manager]Data source name too long

[ISQL]ERROR: Could not SQLConnect

[root@linuxRHEL6 bin]# isql -v simple

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

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

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

SQL> select * from dual;

+------+

| DUMMY|

+------+

| X    |

+------+

SQLRowCount returns -1

1 rows fetched