[R] ROracle issues

[Don MacQueen]

You may have a confusion between 64 bit and 32 bit versions. (I'm not 
certain; I haven't studied your transcript in complete detail, but 
rather just noticed a couple of things.)

There are a lot of references in your transcript to 64 bit libraries, 
e.g. "gcc -I/usr/lib64 ..." but I think that $ORACLE_HOME/lib is a 
reference to Oracle's 32 bit libraries.

ROracle offers some INSTALL flags to specify 32 bit or 64 bit, so you 
might try figuring out which one you want, and specifying it.

There is also the R-sig-db mailing list, which might be a better place to ask.

-Don


At 11:15 AM -0600 4/30/07, Matt Anthony wrote:
>Hi all -
>
>
>
>I am trying to install ROracle for linux machines ... I have read the
>INSTALL documentation and followed the directions for setting the paths
>as follows:
>
>
>
>export PATH=/app/oracle/product/10.2.0/db_1/bin:$PATH
>
>[manthony at diamondback ~]$ export
>LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/lib:/app/oracle/product/10.1.0/db_1
>/lib32:/app/oracle/product/10.1.0/db_1/lib:/app/oracle/product/10.1.0/db
>_1/lib64
>
>
>
>As directed by the INSTALL document. Executing the install by running
>
>
>
>sudo R CMD INSTALL ROracle_0.5-8.tar.gz
>
>
>
>gives me the following:
>
>
>
>* Installing *source* package 'ROracle' ...
>
>checking for gcc... gcc
>
>checking for C compiler default output... a.out
>
>checking whether the C compiler works... yes
>
>checking whether we are cross compiling... no
>
>checking for suffix of executables...
>
>checking for suffix of object files... o
>
>checking whether we are using the GNU C compiler... yes
>
>checking whether gcc accepts -g... yes
>
>checking for gcc option to accept ANSI C... none needed
>
>checking how to run the C preprocessor... gcc -E
>
>configure: creating ./config.status
>
>config.status: creating src/Makevars
>
>config.status: creating src/Makefile
>
>** libs
>
>** arch -
>
>R CMD COMPILE RS-DBI.c
>
>make[1]: Entering directory `/tmp/R.INSTALL.e14574/ROracle/src'
>
>gcc -I/usr/lib64/R/include -I/usr/lib64/R/include
>-DRS_ORA_SQLGLS_WORKAROUND -I/usr/local/include    -fpic  -O2 -g
>-std=gnu99 -c RS-DBI.c -o RS-DBI.o
>
>make[1]: Leaving directory `/tmp/R.INSTALL.e14574/ROracle/src'
>
>proc CODE=ANSI_C MODE=ORACLE INCLUDE=/usr/lib64/R/include \
>
>                 PARSE=NONE LINES=false PREFETCH=1 RS-Oracle.pc
>
>proc: error while loading shared libraries: libclntsh.so.10.1: cannot
>open shared object file: No such file or directory
>
>make: *** [RS-Oracle.c] Error 127
>
>ERROR: compilation failed for package 'ROracle'
>
>** Removing '/usr/lib64/R/library/ROracle'
>
>
>
>
>
>Now, to check for the libclntsh.so.10.1 file, did the following:
>
>
>
>CD $ORACLE_HOME/lib
>
>Ls
>
>
>
>In which the file libclntsh.so.10.1 actually does exist, even though the
>error message seems to imply it doesn't. I have searched the archives
>but found no record of a solution to this problem, and the documentation
>provided with the package does not address this issue as far as I can
>tell. Can someone please explain/point me in the right direction?
>
>
>
>Thank you
>
>
>
>Matt
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>Matt Anthony | Senior Statistician| 303.327.1761 |
>matt.anthony at NextAction.Net
>10155 Westmoor Drive | Westminster, CO 80021 | FAX 303.327.1650
>
>
>
>
>
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at 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.


-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA