Skip to content

ROracle problem with Oracle9i on Red Hat 8.0

2 messages · michael.seewald@vie.boehringer-ingelheim.com, David James

michael.seewald@vie.boehringer-ingelheim.com
# 
Hi,

I have a problem executing "library(ROracle)" in R:

OS/Software:
Redhat 8.0, all available patches applied
Oracle 9i v9.2.0.1.0
R v1.7.0
ROracle v0.5-0
DBI v0.1-5

The compilation and installation of ROracle went fine. However when I try to
load ROracle I get the following:
"/home/michael/software/R/R-1.7.0/library/ROracle/libs/ROracle.so":
undefined symbol: sqlca
The 2 solutions mentioned in ROracle/inst/INSTALL don't seem to help (1:
define $LD_LIBRARY_PATH, 2: compile statically).

Is there any solution to this? I would greatly appreciate any help!!

Best wishes,
Michael Seewald

---
Michael Seewald, PhD
Boehringer Ingelheim Austria
Dept NCE Lead Discovery - Bioinformatics
Dr. Boehringergasse 5-11
A-1121 Vienna, Austria
Tel.: ++43-1-80105-2786
Fax: ++43-1-80105-2683
email: Michael.Seewald at vie.boehringer-ingelheim.com
David James
# 
Hmm. I don't have (easy) access to Oracle9i, but I'd try to find
out whether the client library is indeed in the $ORACLE_HOME/lib
directory.  (I think the file name is something like "libclntst9.xx"
where xx may be "so" or "a").  Don MacQueen reported a similar
problem on Mac OS X, and he posted a workaround on the r-sig-mac list
on 7 Feb 2003.  I'm including here the relevant part of his posting:


DM = Don MacQueen

DM> The first work around is this:
DM> 
DM> cp  $ORACLE_HOME/rdbms/lib/libclntst9.a $ORACLE_HOME/lib
DM> cd $ORACLE_HOME/lib
DM> ranlib -s libclntst9.a
DM> 
DM> (look in the file $ORACLE_HOME/precomp/lib/env_precomp.mk for 
DM> references to libclntst9.a)
DM> 
DM> The absence of libclntst9.a in $ORACLE_HOME/lib may represent an 
DM> error in the Oracle distribution, or it may represent a lack of 
DM> understanding on my part.
DM> 

--
David
michael.seewald at vie.boehringer-ingelheim.com wrote: