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

From: Mathieu Drapeau <mathieu.drapeau_at_mcgill.ca>
Date: Thu 21 Sep 2006 - 19:12:46 GMT

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



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Fri Sep 22 05:28:03 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 21 Sep 2006 - 20:30:18 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.