[R] ROracle problem with Oracle9i on Red Hat 8.0

[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:
> 
> 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:
> >> library(ROracle)
> >Error in dyn.load(x, as.logical(local), as.logical(now)) :
> >        unable to load shared library
> "/home/michael/software/R/R-1.7.0/library/ROracle/libs/ROracle.so":
> >  /home/michael/software/R/R-1.7.0/library/ROracle/libs/ROracle.so:
> undefined symbol: sqlca
> >Error in library(ROracle) : .First.lib failed
> 
> 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
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help

-- 
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636