Visit The New, Modern Unix Linux Community


Got Error Using Oracle Instant Client with UNIXODBC


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Got Error Using Oracle Instant Client with UNIXODBC
# 1  
Got Error Using Oracle Instant Client with UNIXODBC

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:

Code:
$ 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:

Code:
$ 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:

Code:
$ 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
Code:
[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
Code:
[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         =

---------- Post updated at 11:09 PM ---------- Previous update was at 04:07 AM ----------

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 ?
# 2  
Your env shows you have LIBPATH as the library path. Could you try adding oracle instant directory to this path?

Code:
LIBPATH=$LIBPATH:/usr/local/instantclient_12_1 
export LIBPATH


EDIT : Welcome to the forums Smilie
# 3  
Hi clx,

My libpath do have the library folder to the odbc lib.
last 2 paragraph.

--
Raymond
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #811
Difficulty: Easy
RGBA stands for red green blue alpha.
True or False?

7 More Discussions You Might Find Interesting

1. Red Hat

Instant client

Hi, Could you please tell me how to check instant client is installed in Linux server? OS -- Linux 5.11 Oracle -- 10.2.0.5.0 Regards, Maddy (2 Replies)
Discussion started by: Maddy123
2 Replies

2. UNIX for Dummies Questions & Answers

Oracle client install for AIX - WinSCP fails

I am trying to install the oracle client for AIX. I downloaded the client to my Windows machine from Oracle Database 10g Release 2 for AIX5L "Oracle Database 10g Client Release 2 (10.2.0.1.0)". 1. Is this right? (I need 9 or 10 client) It was .gz file that I am now trying to move from... (2 Replies)
Discussion started by: shoefiend
2 Replies

3. Programming

How to make communication with Oracle dbms_pipe with .net client?

So, I have a 'task' to create communication channel between Oracle db (11gR2 on AIX) and some client wich is choosed to be a .net client (.net framework 3.5). we created a pipe on client (.net) side using: System.IO.Pipes.NamedPipeClientStream pipeClient = new... (2 Replies)
Discussion started by: bongo
2 Replies

4. AIX

Oracle client install on AIX 5.3

I have been tasked with creating a scripted install of the Oracle client (9.2.0.1.0). However from what I have discovered this is an X / Java install application and cannot be run without the DISPLAY being set and exported. Does anyone know of a way of installing the client from a character based... (3 Replies)
Discussion started by: johnf
3 Replies

5. UNIX for Advanced & Expert Users

install centos with php and oracle client

Hi i'm trying to install centos ver 5 with apache server 1.3 and need to install oracle client to connect from the php to oracle data base. the problem is that evry package that i install needs some dependencis and i coudent figure yet the right combination. can any one help me to find... (3 Replies)
Discussion started by: lione.heart
3 Replies

6. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

7. Debian

all instant client on debian hppa

Hello, I want to install PHP/PECL OCI8 on an HP J2240 (with Debian hppa 4.0r1 lenny (PA-RISC)) and to do this I must install an Oracle client. I don't find anything about this, help me, please? Thanks you for reply. (2 Replies)
Discussion started by: nonyus
2 Replies

Featured Tech Videos