[R] ROracle issue with shared library and RMySQL

[Prof Brian Ripley]

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