R help - Sep 2006 - [ROracle] error loading (undefined symbol: sqlclu)

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

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