[R-sig-DB] Problem installing Roracle in RHEL5

[MacQueen, Don]

I�m having trouble installing Roracle_0.5-9 in R version 2.11.1 on a RHEL5 machine.

Here is the error message (full transcript at the end of this email):

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.11.1: cannot open shared object file: No such file or directory

However, the file libclntsh.so.11.1 is present in $ORACLE_HOME/lib, and is not empty.

[157]% ls -l $ORACLE_HOME/lib/libclntsh.*
lrwxrwxrwx 1 root   root           17 Aug 19 14:09 /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so -> libclntsh.so.11.1*
lrwxrwxrwx 1 root   root           17 Aug 19 14:10 /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.10.1 -> libclntsh.so.11.1*
-rwxr-xr-x 1 oracle oinstall 48724689 Sep 15  2009 /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1*

I had previously succeeded in installing Roracle on this machine; in fact, it�s still there, but:
> require(ROracle)
Loading required package: ROracle
Error: package 'ROracle' was built before R 2.10.0: please re-install it

And I recall running $ORACLE_HOME/bin/genclntsh, which is why the required lib file has non-zero size.

Given the error message, perhaps the ROracle installer is not looking in the right place, but if so I haven�t succeeded in ensuring it does. I have set LD_LIBRARY_PATH to include $ORACLE_HOME/lib.

Suggestions would be much appreciated. I feel like I�m forgetting something that I�ve done before to install ROracle, but can�t think what it was.

-Don



Further informaton:

> sessionInfo()
R version 2.11.1 (2010-05-31)
x86_64-redhat-linux-gnu

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8
 [5] LC_MONETARY=C              LC_MESSAGES=en_US.UTF-8
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C
 [9] LC_ADDRESS=C               LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base



> install.packages('ROracle')
Warning in install.packages("ROracle") :
  argument 'lib' is missing: using '/usr/lib64/R/library'
trying URL 'http://cran.cnr.Berkeley.edu/src/contrib/ROracle_0.5-9.tar.gz'
Content type 'application/x-gzip' length 155808 bytes (152 Kb)
opened URL
==================================================
downloaded 152 Kb

Loading required package: rmacq
* installing *source* package � ...
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/RtmpHDWrkX/R.INSTALL327b23c6/ROracle/src'
gcc -m64 -std=gnu99 -I/usr/include/R -DRS_ORA_SQLGLS_WORKAROUND -I/usr/local/include    -fpic  -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -c RS-DBI.c -o RS-DBI.o
RS-DBI.c: In function �:
RS-DBI.c:1175: warning: assignment discards qualifiers from pointer target type
RS-DBI.c:1188: warning: implicit declaration of function �
RS-DBI.c: In function �:
RS-DBI.c:1226: warning: assignment discards qualifiers from pointer target type
make[1]: Leaving directory `/tmp/RtmpHDWrkX/R.INSTALL327b23c6/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.11.1: cannot open shared object file: No such file or directory
make: *** [RS-Oracle.c] Error 127
ERROR: compilation failed for package �

--
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
925 423-1062

	[[alternative HTML version deleted]]