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

[Mathieu Drapeau]

Hi Marc,
thanks for the answer, but that wasn't the problem.
I set my LD_LIBRARY_PATH in my .cshrc.

I solve my problem by compiling the library manually. It created me a 
file (ROracle.so) of ~14mb (instead of the one of ~150K) that I replaced 
with the other one.
I guess R compilation did something wrong.

Thanks,
Mathieu

Marc Schwartz (via MN) wrote:

>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
>
>
>
>  
>