R devel - Jan 2008 - "ROracle" Packages is not to be installed (PR#10652)

Full_Name: JinNyong Huh
Version: 2.6.1
OS: Linux(SUSE-9.0)
Submission from: (NULL) (220.75.209.235)


ROracle Packages is not to be installed in my Linux.

The enviroments are as follows:
* O/S Profile
[
export ORACLE_BASE=/opt/oracle

export ORACLE_SID=DEMO10G
export ORACLE_HOME=$ORACLE_BASE/product/10g
export ORACLE_DOC=$ORACLE_HOME/doc
export ORACLE_TERM=vt220
export TERM=vt100
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS10=$ORACLE_HOME/nls/data
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_CLIENT_LIB=shared
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/bin:.:/opt/R-2.6.1-patched/bin:$PATH
export LIBPATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib
export SHLIB_PATH=/home/ofsa45/ofsa4.5-092-linux/lib:$ORACLE_HOME/lib
export
LD_LIBRARY_PATH=/home/ofsa45/ofsa4.5-092-linux/lib:$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib
export LANG=C
export TMP=$ORACLE_HOME/tmp
export TEMP=$ORACLE_HOME/tmp

export R_HOME=/opt/R-2.6.1-patched
export R_LIBS=/opt/R-2.6.1-patched/lib

stty erase ^H
set -o vi

alias src='cd $HOME/dev/src'
alias include='cd $HOME/dev/include'
alias bin='cd $HOME/dev/bin'
alias mak='cd $HOME/dev/mak'
alias lib='cd $HOME/dev/lib'

#stty -parenb -istrip -ixany cs8
export
PS1='['''$USER''':''$PWD'']'

export CVSROOT=:pserver:jcs at 147.46.153.178:/oracle/cvs/repository
]

And I has made R-executable and run that.

After logging into R-Prompt, I has inputted the commands as follows
* Commands
[
options(CRAN = "http://cran.us.r-project.org/")
install.packages("ROracle") 
]

But I has met the messages like followings and the packages "ROracle"
was not
installed.

* Messages
[
* 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 -
make: Warning: File `/opt/R-2.6.1-patched/share/make/vars.mk' has
modification
time 7.2e+06 s in the future
R CMD COMPILE RS-DBI.c
make[1]: Entering directory `/tmp/R.INSTALL.Po4474/ROracle/src'
make[1]: Warning: File `/opt/R-2.6.1-patched/share/make/vars.mk' has
modification time 7.2e+06 s in the future
gcc -std=gnu99 -I/opt/R-2.6.1-patched/include -I/opt/R-2.6.1-patched/include
-DRS_ORA_SQLGLS_WORKAROUND -I/usr/local/include    -fpic  -g -O2 -c RS-DBI.c -o
RS-DBI.o
RS-DBI.c: In function `RS_DBI_makeSQLNames':
RS-DBI.c:1175: warning: assignment discards qualifiers from pointer target type
RS-DBI.c:1188: warning: implicit declaration of function `isalpha'
RS-DBI.c: In function `RS_na_set':
RS-DBI.c:1226: warning: assignment discards qualifiers from pointer target type
make[1]: warning:  Clock skew detected.  Your build may be incomplete.
make[1]: Leaving directory `/tmp/R.INSTALL.Po4474/ROracle/src'
proc CODE=ANSI_C MODE=ORACLE INCLUDE=/opt/R-2.6.1-patched/include \
                PARSE=NONE LINES=false PREFETCH=1 RS-Oracle.pc

Pro*C/C++: Release 10.2.0.1.0 - Production on Wed Nov 7 05:54:06 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

System default option values taken from:
/opt/oracle/product/10g/precomp/admin/pcscfg.cfg
R CMD COMPILE RS-Oracle.c
make[1]: Entering directory `/tmp/R.INSTALL.Po4474/ROracle/src'
make[1]: Warning: File `/opt/R-2.6.1-patched/share/make/vars.mk' has
modification time 7.2e+06 s in the future
gcc -std=gnu99 -I/opt/R-2.6.1-patched/include -I/opt/R-2.6.1-patched/include
-DRS_ORA_SQLGLS_WORKAROUND -I/usr/local/include    -fpic  -g -O2 -c RS-Oracle.c
-o RS-Oracle.o
RS-Oracle.c: In function `RS_Ora_prepareStatement':
RS-Oracle.c:2382: warning: implicit declaration of function `isalpha'
RS-Oracle.c:2383: warning: implicit declaration of function `toupper'
RS-Oracle.c:2385: warning: implicit declaration of function `isgraph'
RS-Oracle.c: In function `RS_Ora_setSToOraMappings':
RS-Oracle.c:4673: warning: implicit declaration of function `isdigit'
RS-Oracle.c: In function `RS_Ora_cpyDataFrameToOra':
RS-Oracle.c:4849: warning: assignment discards qualifiers from pointer target
type
RS-Oracle.c: In function `RS_SclassNames_To_StypeIds':
RS-Oracle.c:6569: warning: assignment discards qualifiers from pointer target
type
make[1]: warning:  Clock skew detected.  Your build may be incomplete.
make[1]: Leaving directory `/tmp/R.INSTALL.Po4474/ROracle/src'
R CMD SHLIB -o ROracle.so RS-DBI.o RS-Oracle.o
make[1]: Entering directory `/tmp/R.INSTALL.Po4474/ROracle/src'
make[1]: Warning: File `/opt/R-2.6.1-patched/share/make/vars.mk' has
modification time 7.2e+06 s in the future
gcc -std=gnu99 -shared -L/usr/local/lib -o ROracle.so RS-DBI.o RS-Oracle.o
-L/opt/oracle/product/10g/lib -L/opt/oracle/product/10g/network/lib -lclntst10
-lnbeq10 -lnhost10 -lnu
s10 -lnldap10 -lldapclnt10 -lnsslb10 -lntcp10 -lntcps10 -lnsslb10 -lntcp10
-lntns10 -ldl -lm -lpthread -lnsl -lirc -ldl -lm
/opt/oracle/product/10g/lib/libclntst10.a: file not recognized: File truncated
collect2: ld returned 1 exit status
make[1]: *** [ROracle.so] Error 1
make[1]: Leaving directory `/tmp/R.INSTALL.Po4474/ROracle/src'
make: *** [ROracle.so] Error 2
ERROR: compilation failed for package 'ROracle'
** Removing '/opt/R-2.6.1-patched/library/ROracle'

The downloaded packages are in
        /tmp/Rtmpf9ISDj/downloaded_packages
Updating HTML index of packages in '.Library'
Warning message:
In install.packages("ROracle") :
  installation of package 'ROracle' had non-zero exit status
]

Could you give me any solution on this?

Thank you in advance.

bacycho at korea.com wrote:
> /opt/oracle/product/10g/lib/libclntst10.a: file not recognized: File
truncated
Here:

    http://osdir.com/ml/lang.r.mac/2006-08/msg00031.html

I found a suggestion to do this:

    $ cd $ORACLE_HOME/bin
    $ ./genclntst

-- Dave