michael.seewald@vie.boehringer-ingelheim.com
2003-May-14 11:53 UTC
[R] ROracle problem with Oracle9i on Red Hat 8.0
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 failedThe 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
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