On Wed, 2006-09-20 at 15:15 -0400, Mathieu Drapeau wrote: > I have this error when I load the library ROracle: > > library(ROracle) > Loading required package: DBI > Error in dyn.load(x, as.logical(local), as.logical(now)) : > unable to load shared library > '/usr/local/lib/R/site-library/ROracle/libs/ROracle.so': > /usr/local/lib/R/site-library/ROracle/libs/ROracle.so: undefined > symbol: sqlclu > Error in library(ROracle) : .First.lib failed for 'ROracle' > > > > Also, my LD_LIBRARY_PATH seems to be set correctly: > drapeau:~> echo $LD_LIBRARY_PATH > /home/drapeau/lib:/opt/oracle/xe/app/oracle/product/10.2.0/client/lib > > I installed the big database applications (10g) and ROracle 0.5-7 > > Your help will be very appreciated to help me solve this error, > Thank you, > Mathieu
Where did you set LD_LIBRARY_PATH? If in one of your shell config files, it is likely that it is being stepped on during your login and thus not being seen within the R session. I had this problem previously and set the variable in /etc/ld.so.conf (though I am using RODBC instead). Edit that file (as root), add the path: /opt/oracle/xe/app/oracle/product/10.2.0/client/lib and then run [/sbin/]ldconfig to update the current settings. Be sure also that $ORACLE_HOME is set to /opt/oracle/xe/app/oracle/product/10.2.0/client Then try to load ROracle in a new R session. HTH, Marc Schwartz ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
