[R] [ROracle] error loading (undefined symbol: sqlclu)

[Marc Schwartz (via MN)]

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