[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':
>   /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

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
to /opt/oracle/xe/app/oracle/product/10.2.0/client

Then try to load ROracle in a new R session.


Marc Schwartz

More information about the R-help mailing list