[R] [ROracle] error loading (undefined symbol: sqlclu)
Marc Schwartz (via MN)
mschwartz at mn.rr.com
Wed Sep 20 21:46:53 CEST 2006
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: 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
> 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,
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
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:
and then run [/sbin/]ldconfig to update the current settings.
Be sure also that $ORACLE_HOME is set
Then try to load ROracle in a new R session.
More information about the R-help