Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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:

[Oracle]
Description = Oracle ODBC Connection
Driver = /usr/lib/libsqora.so.11.1
Setup =
FileUsage =

and my /etc/odbc.ini file:

[Oracle]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = //<host>:<port>/<db>
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
UserID =

(ServerName has been edited...host, port, and db are actually there, and correct)

When I run isql I get

$ isql -v Oracle
isql: symbol lookup error: /usr/lib/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW

And running dltest gives me

$ dltest Oracle SQLConnect
[dltest] ERROR dlopen: Oracle: cannot open shared object file: No such file or directory

If anyone has any insights I would be grateful, I've been trying to get this to connect for about 5 hours now...

I am going home for the night, but will gladly provide more details, if necessary, tomorrow morning, to anyone willing to help...

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

You might want to check this discussion in the OTN forums. The relevant discussion occurs about 75% of the way into the thread, second post by user ardesai.

share|improve this answer
1  
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_P Apr 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
    
I downloaded the 2.2.14 binary file from sourceforge.net/projects/unixodbc/files/unixODBC/2.2.14, then tar xf unixODBC-2.2.14-linux-x86-64.tar.gz -C / to overwrite the orginal unixODBC-2.2.11 files, now it working! –  LiuYan 刘研 Nov 2 '11 at 8:58
add comment

New and Oracle client compatible unixODBC64 packages have just been released in RHEL5.8.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.