I am trying to configure our web server (RHEL 5.4 x86) to connect to an Oracle database using unixODBC. I have installed unixODBC-2.2.11-7.1.1, which yum tells me is the latest version. I have also installed the Oracle InstantClient 11.2 and the Oracle InstantClient ODBC library.

I have symlinked the all the .so files in /usr/lib/oracle/11.2/client/lib to /usr/lib. I have set $LD_LIBRARY_PATH to /usr/lib/, $ORACLE_HOME to /usr/lib/oracle and $TNS_ADMIN to the directory containing my (valid) Tnsnames.ora file. Here are the contents of my /etc/odbcinst.ini file:

yea, definitely ran across that post during my struggle. I eventually got it working, only to discover that php's odbc driver had a bug when used with an oracle odbc connection. so in the end i gave up, installed php-oci, and called it a day...
–
W_PApr 11 '10 at 18:14

hmm, I encountered exactly the same problem. I can run sqlplus with no problem, but isql just failed as W_P post. I guess unixODBC 2.2.11 is too old to Oracle InstantClient 11.2
–
LiuYan 刘研Nov 2 '11 at 4:16