[unixODBC-support] isql cannot find Oracle driver on Fedora Rawhide (64-bit)

Nick Gorham nick at lurcher.org
Wed Apr 29 07:54:40 BST 2009


Angela Johansson wrote:
> Hi All,
>
> I have problems connecting to my database server. Running isql against
> Oracle's own driver gives the following output:
>
> [oracle at vierstein ~]$ isql -v  OracleODBC-11g
> [01000][unixODBC][Driver Manager]Can't open lib
> '/usr/local/share/oracle/11g/lib/libsqora.so.11.1' : file not found
> [ISQL]ERROR: Could not SQLConnect
>
> I know the library is there and I also checked the versions, since I
> am running a 64-bit OS:
>
> [oracle at vierstein ~]$ file /usr/local/share/oracle/11g/lib/libsqora.so.11.1
> /usr/local/share/oracle/11g/lib/libsqora.so.11.1: ELF 64-bit LSB
> shared object, x86-64, version 1 (SYSV),
> dynamically linked, not stripped
> [oracle at vierstein ~]$ file /usr/bin/isql
> /usr/bin/isql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV),
> dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped
>
> They both exist and are 64-bit files. Why doesn't isql find the library?
>
> With easysoft's driver, I get the same output (with a different path of course):
>
> [oracle at vierstein ~]$ isql -v  ORACLE
> [01000][unixODBC][Driver Manager]Can't open lib
> '/usr/local/easysoft/oracle/libesoracle.so' : file not found
> [ISQL]ERROR: Could not SQLConnect
> [oracle at vierstein ~]$ file /usr/local/easysoft/oracle/libesoracle.so
> /usr/local/easysoft/oracle/libesoracle.so: ELF 64-bit LSB shared
> object, x86-64, version 1 (SYSV), dynamically linked, not stripped
>
> I also tried copying the library to /usr/lib64 and installing 32-bit
> unixODBC using the 32-bit version of the driver - nothing works. Does
> anybody know what's wrong or can give me any hint as to what I should
> double-check?
>
> I am running Fedora Rawhide (the development version of Fedora), the
> installed unixODBC package is unixODBC-2.2.14-2.fc11.x86_64.rpm and
> the installed database server is Oracle Database 11g.
>
> Thanks in advance for your effort.
>
> Regards,
> /Angela J
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>   

Try a

ldd /usr/local/easysoft/oracle/libesoracle.so

and

ldd /usr/local/share/oracle/11g/lib/libsqora.so.11.1

And see what it says. Also check that SELinux isn't preventing the libs 
from being loaded.

-- 
Nick


More information about the unixODBC-support mailing list