Got Error Using Oracle Instant Client with UnixODBC

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Got Error Using Oracle Instant Client with UnixODBC

raymond p
This post has NOT been accepted by the mailing list yet.
Server : AIX 5.3
UnixODBC = 2.2.15pre
Driver = Oracle ODBC Instant Client AIX 64bit,  Oracle Basic Instant Client AIX 64bit

We tried to connect Oracle 11g(Windows) from AIX.
Anyway when we try to use isql to access the connection and we got error message as below:

$ isql -v ORA_IIID_TEST_SVR
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/instantclient_12_1/libsqora.so.12.1' : file not found
[ISQL]ERROR: Could not SQLConnect


After that we ldd the file and got the message below:

$ ldd /usr/local/instantclient_12_1/libsqora.so
/usr/local/instantclient_12_1/libsqora.so needs:
         /usr/local/unixODBC/lib/libodbcinst.a(libodbcinst.so.2)
ar: 0707-109 Member name libodbcinst.so.2 does not exist.
dump: /tmp/tmpdir790564/extract/libodbcinst.so.2: 0654-106 Cannot open the specified file.
         /usr/local/instantclient_12_1/libclntsh.so
         /usr/lib/libc.a(shr_64.o)
         /unix
         /usr/local/instantclient_12_1/libclntshcore.so
         /usr/lib/libperfstat.a(shr_64.o)
         /usr/lib/libpthreads.a(shr_xpg5_64.o)
         /usr/lib/libc.a(aio_64.o)
         /usr/lib/libdl.a(shr_64.o)
         /usr/local/instantclient_12_1/libons.so
         /usr/lib/libcrypt.a(shr_64.o)
         /usr/lib/libodm.a(shr_64.o)
         /usr/lib/libcfg.a(shr_64.o)
         /usr/lib/liblvm.a(shr_64.o)


Any hints what's the problem from above error?

Some info of our config:

$ env
_=/usr/bin/env
LANG=en_US
LOGIN=sas
PATH=/usr/local/unixODBC/etc:/usr/local/unixODBC/bin:/usr/local/unixODBC/lib:
/home/db2inst1/sqllib/lib:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:
/usr/java14/jre/bin:/usr/java14/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:
/home/sas/bin:/usr/bin/X11:/sbin:.:/usr/local/SYBASEIQCLIDriver64/IQ-15_0/bin:/usr/local/SYBASEIQCLIDriver64/IQ-15_0/lib64
LC__FASTMSG=true
LOGNAME=sas
MAIL=/usr/spool/mail/sas
LOCPATH=/usr/lib/nls/loc
USER=sas
AUTHSTATE=compat
ODBCHOME=/usr/local/unixODBC
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
ODBCINI=/usr/local/unixODBC/etc/odbc.ini
HOME=/home/sas
SYB=/usr/local/SYBASEIQCLIDriver64/IQ-15_0
DB2INSTANCE=db2inst1
TERM=xterm
MAILMSG=[YOU HAVE NEW MAIL]
TWO_TASK=//server_ip_address:1521/orcl
ORACLE_HOME=/usr/local/instantclient_12_1
ODBCINST=odbcinst.ini
PWD=/usr/local/unixODBC/bin
TZ=WAUST-8
CLI=/home/db2inst1/sqllib
AIXTHREAD_SCOPE=S
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/local/unixODBC/lib:/usr/local/thinodbc51:/home/db2inst1/sqllib/lib:
/usr/local/SYBASEIQCLIDriver64/IQ-15_0/lib64:/usr/local/instantclient_12_1
LD_LIBRARY_PATH=/usr/local/instantclient_12_1



odbc.ini
[ORA_IIID_TEST_SVR]
Driver = Oracle 12c ODBC driver
Description = IIID Oracle Test Server
Userid = system
Password = Passw0rd
Trace = Yes
TraceFile = /tmp/trc_ora.log
Database = //server_ip_address:1521/orcl
Port = 1521



odbcinst.ini
[Oracle 12c ODBC driver]
Description     = Oracle ODBC driver for Oracle 12c
Driver          = /usr/local/instantclient_12_1/libsqora.so.12.1
Setup           =
FileUsage       =
CPTimeout       =
CPReuse         =


regards
Raymond P
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Got Error Using Oracle Instant Client with UnixODBC

raymond p
This post has NOT been accepted by the mailing list yet.
1)Install the latest unixodbc will help in the case ?
2)If install latest version unixodbc , will it impact my other odbc connection currently use ?

Loading...