Re: [R] [ROracle] error loading (undefined symbol: sqlclu)
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.
[R] [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 __ 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.
Re: [R] [ROracle] error loading (undefined symbol: sqlclu)
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.
