R CMD ldd /usr/local/lib/R/library/ROracle/libs/ROracle.so
should help. (Assuming this is Linux, a piece of information I am
guessing from the kernel number. What or who is `Gentoo'?) You are
looking for either unsatisfied dependencies or a lack of expected Oracle
dependencies.
On Sun, 23 Nov 2003, Coburn Watson wrote:
> Hello,
>
> Someone posted this same issue back in May 2003 and hasn't yet resolved
the
> situation. I hope someone can provide some additional light.
>
> After starting R I attempt to load the ROracle library and receive the
> following message:
>
> > library(ROracle)
> Error in dyn.load(x, as.logical(local), as.logical(now)) :
> unable to load shared library
> "/usr/local/lib/R/library/ROracle/libs/ROracle.so":
> /usr/local/lib/R/library/ROracle/libs/ROracle.so: undefined symbol: sqlca
> Error in library(ROracle) : .First.lib failed
>
> My configuration:
> Gentoo 1.4 - kernel 2.4.20
> Oracle 9.2.0.4 (upgraded 9.2.0.2)
>
> I compiled ROracle with the necessary Oracle libraries in the path. My
> LD_LIBRARY_PATH is set to:
>
>
/u01/app/oracle/product/9.2.0/lib:/u01/app/oracle/product/9.2.0/precomp/public
>
:/u01/app/oracle/product/9.2.0/sqlplus/public:/u01/app/oracle/product/9.2.0/precomp/lib
>
> My other oracle applications run fine as far as I can tell. I can also
compile
> and execute the Oracle sample12 which does an include of sqlca.h and uses
> dynamic SQL (under the same envrionment conditions). Is there a way to
dump
> the environment which R executes under? Maybe something is getting dropped.
>
> Any help is appreciated.
>
> Coburn Watson
> cpwww at comcast.net
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
>
--
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595