This discussion is archived
5 Replies Latest reply: Oct 11, 2012 9:08 AM by 962179 RSS

Unable to install ROracle_1.1-5 under Windows XP 32bit

962179 Newbie
Currently Being Moderated
My setup is: R version 2.15.0, Rtools 2.15. Steps followed:

1) Downloaded and unzipped oracle instant client (basic, sdk, odbc) into c:\instantclient\i386\instantclient_11_2.
2) Downloaded and installed DBI from within the R GUI.
3) Downloaded and tried to install ROracle using: R CMD INSTALL --build ROracle_1.1-5.tar.gz

At some point during the compilation I get many "undefined reference" errors:

C:\instantclient\i386>"C:\Programmi\R\R-2.15.0\bin\i386\R.exe" CMD INSTALL ROracle_1.1-5
[...]
found Instant Client c:/instantclient/i386/instantclient_11_2
found Instant Client SDK c:/instantclient/i386/instantclient_11_2/sdk/include
[...]
gcc -I"C:/Programmi/R/R-2.15.0/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -mtune=core2 -c rodbi.c -o rodbi.o
gcc -I"C:/Programmi/R/R-2.15.0/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -mtune=core2 -c rooci.c -o rooci.o
In file included from C:/Programmi/R/R-2.15.0/include/R.h:44:0,
from rodbi.h:37,
from rooci.c:52:
C:/Programmi/R/R-2.15.0/include/R_ext/RS.h:43:0: warning: "ERROR" redefined [enabled by default]
c:\rtools\gcc-4.6.3\bin\../lib/gcc/i686-w64-mingw32/4.6.3/../../../../i686-w64-mingw32/include/wingdi.h:70:0: note: this is the location of the previous definition
gcc -shared -s -static-libgcc -o ROracle.dll tmp.def rodbi.o rooci.o -L -loci -L C:/Programmi/R/R-2.15.0/bin/i386 -lR
rooci.o:rooci.c:(.text+0x82): undefined reference to `OCIDescriptorAlloc'
rooci.o:rooci.c:(.text+0xc3): undefined reference to `OCIDescriptorAlloc'
[...]
collect2: ld returned 1 exit status
[...]
Error in library.dynam(lib, package, package.lib) :
DLL 'ROracle' not found: maybe not installed for this architecture?

I can post more output/details if necessary.
Thank you for your support!

Renato
  • 1. Re: Unable to install ROracle_1.1-5 under Windows XP 32bit
    339359 Newbie
    Currently Being Moderated
    Hi Renato,

    What version of Instant client did you download? Is it 11.2.0.1? What files are present in c:\instantclient\i386\instantclient_11_2 directory? Can you post the detailed list? It seems that the entry point for OCIDescriptorAlloc is not found in oci.dll, what other functions have undefined referenced?

    Thanks,
    ROracle Team
  • 2. Re: Unable to install ROracle_1.1-5 under Windows XP 32bit
    962179 Newbie
    Currently Being Moderated
    Many thanks for your fast response! Replies to your query follow below.

    Once again thank you very much indeed and kind regards,
    Renato
    What version of Instant client did you download? Is it 11.2.0.1?
    It is 11.2.0.3.0 (instantclient-basic-nt-11.2.0.3.0.zip, same for sdk, odbc).
    Installation also fails under a Windows Server 2008 R2 Enterprise 64 bit, with R x64 2.15.1 with Instant client version instantclient-basic-windows.x64-11.2.0.3.0.zip (same for sdk odbc), with similar error messages (I can post them as well if you need them).

    What files are present in c:\instantclient\i386\instantclient_11_2 directory? Can you post the detailed list?
    Here is the output of dir /s /b instantclient_11_2

    C:\instantclient\i386\instantclient_11_2\adrci.exe
    C:\instantclient\i386\instantclient_11_2\adrci.sym
    C:\instantclient\i386\instantclient_11_2\BASIC_README
    C:\instantclient\i386\instantclient_11_2\genezi.exe
    C:\instantclient\i386\instantclient_11_2\genezi.sym
    C:\instantclient\i386\instantclient_11_2\oci.dll
    C:\instantclient\i386\instantclient_11_2\oci.sym
    C:\instantclient\i386\instantclient_11_2\ocijdbc11.dll
    C:\instantclient\i386\instantclient_11_2\ocijdbc11.sym
    C:\instantclient\i386\instantclient_11_2\ociw32.dll
    C:\instantclient\i386\instantclient_11_2\ociw32.sym
    C:\instantclient\i386\instantclient_11_2\ODBCRelnotesUS.htm
    C:\instantclient\i386\instantclient_11_2\ODBC_IC_Readme_Win.html
    C:\instantclient\i386\instantclient_11_2\odbc_install.exe
    C:\instantclient\i386\instantclient_11_2\odbc_uninstall.exe
    C:\instantclient\i386\instantclient_11_2\ojdbc5.jar
    C:\instantclient\i386\instantclient_11_2\ojdbc6.jar
    C:\instantclient\i386\instantclient_11_2\orannzsbb11.dll
    C:\instantclient\i386\instantclient_11_2\orannzsbb11.sym
    C:\instantclient\i386\instantclient_11_2\oraocci11.dll
    C:\instantclient\i386\instantclient_11_2\oraocci11.sym
    C:\instantclient\i386\instantclient_11_2\oraociei11.dll
    C:\instantclient\i386\instantclient_11_2\oraociei11.sym
    C:\instantclient\i386\instantclient_11_2\orasql11.dll
    C:\instantclient\i386\instantclient_11_2\orasql11.sym
    C:\instantclient\i386\instantclient_11_2\sdk
    C:\instantclient\i386\instantclient_11_2\sqora.chm
    C:\instantclient\i386\instantclient_11_2\sqora32.dll
    C:\instantclient\i386\instantclient_11_2\sqoras32.dll
    C:\instantclient\i386\instantclient_11_2\sqresus.dll
    C:\instantclient\i386\instantclient_11_2\uidrvci.exe
    C:\instantclient\i386\instantclient_11_2\uidrvci.sym
    C:\instantclient\i386\instantclient_11_2\vc8
    C:\instantclient\i386\instantclient_11_2\vc9
    C:\instantclient\i386\instantclient_11_2\xstreams.jar
    C:\instantclient\i386\instantclient_11_2\sdk\demo
    C:\instantclient\i386\instantclient_11_2\sdk\include
    C:\instantclient\i386\instantclient_11_2\sdk\lib
    C:\instantclient\i386\instantclient_11_2\sdk\ott.bat
    C:\instantclient\i386\instantclient_11_2\sdk\ottclasses.zip
    C:\instantclient\i386\instantclient_11_2\sdk\SDK_README
    C:\instantclient\i386\instantclient_11_2\sdk\demo\bcmake.bat
    C:\instantclient\i386\instantclient_11_2\sdk\demo\cdemo81.c
    C:\instantclient\i386\instantclient_11_2\sdk\demo\make.bat
    C:\instantclient\i386\instantclient_11_2\sdk\demo\occidemo.sql
    C:\instantclient\i386\instantclient_11_2\sdk\demo\occidemod.sql
    C:\instantclient\i386\instantclient_11_2\sdk\demo\occidml.cpp
    C:\instantclient\i386\instantclient_11_2\sdk\demo\occiobj.cpp
    C:\instantclient\i386\instantclient_11_2\sdk\demo\occiobj.typ
    C:\instantclient\i386\instantclient_11_2\sdk\include\ldap.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\nzerror.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\nzt.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occi.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occiAQ.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occiCommon.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occiControl.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occiData.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\occiObjects.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\oci.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\oci1.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\oci8dp.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ociap.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ociapr.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocidef.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocidem.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocidfn.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ociextp.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocikpr.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocixml.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocixmldb.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ocixstream.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\odci.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\oratypes.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ori.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\orid.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\orl.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\oro.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\ort.h
    C:\instantclient\i386\instantclient_11_2\sdk\include\xa.h
    C:\instantclient\i386\instantclient_11_2\sdk\lib\bc
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc
    C:\instantclient\i386\instantclient_11_2\sdk\lib\bc\oci.lib
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\oci.lib
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\ociw32.lib
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\oraocci11.lib
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\vc8
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\vc9
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\vc8\oraocci11.lib
    C:\instantclient\i386\instantclient_11_2\sdk\lib\msvc\vc9\oraocci11.lib
    C:\instantclient\i386\instantclient_11_2\vc8\oraocci11.dll
    C:\instantclient\i386\instantclient_11_2\vc8\oraocci11.sym
    C:\instantclient\i386\instantclient_11_2\vc9\oraocci11.dll
    C:\instantclient\i386\instantclient_11_2\vc9\oraocci11.sym

    It seems that the entry point for OCIDescriptorAlloc is not found in oci.dll, what other functions have undefined referenced?
    Many other functions have undef ref. Full output of R CMD INSTALL ROracle_1.1-5.tar.gz:

    C:\instantclient\i386>C:\Programmi\R\R-2.15.0\bin\i386\R.exe CMD INSTALL ROracle_1.1-5
    * installing to library 'C:/Programmi/R/R-2.15.0/library'
    * installing source package 'ROracle' ...
    ** package 'ROracle' successfully unpacked and MD5 sums checked
    looking for Instant Client c:/instantclient/i386/instantclient_11_2
    cygwin warning:
    MS-DOS style path detected: c:/instantclient/i386/instantclient_11_2
    Preferred POSIX equivalent is: /cygdrive/c/instantclient/i386/instantclient_11_2
    CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
    http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
    found Instant Client c:/instantclient/i386/instantclient_11_2
    found Instant Client SDK c:/instantclient/i386/instantclient_11_2/sdk/include
    copying from c:/instantclient/i386/instantclient_11_2
    copying from c:/instantclient/i386/instantclient_11_2/sdk/include
    ** libs
    Warning: this package has a non-empty 'configure.win' file,
    so building only the main architecture

    cygwin warning:
    MS-DOS style path detected: C:/Programmi/R/R-2.15.0/etc/i386/Makeconf
    Preferred POSIX equivalent is: /cygdrive/c/Programmi/R/R-2.15.0/etc/i386/Makeconf
    CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
    http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
    gcc -shared -s -static-libgcc -o ROracle.dll tmp.def rodbi.o rooci.o -L -loci -L
    C:/Programmi/R/R-2.15.0/bin/i386 -lR
    rooci.o:rooci.c:(.text+0x82): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0xc3): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x136): undefined reference to `OCIDateTimeConstruct'
    rooci.o:rooci.c:(.text+0x17f): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x1c0): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x1f0): undefined reference to `OCIDateTimeSysTimeStamp'
    rooci.o:rooci.c:(.text+0x221): undefined reference to `OCIDateTimeGetTimeZoneOffset'
    rooci.o:rooci.c:(.text+0x233): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x27f): undefined reference to `OCIIntervalSetDaySecond'
    rooci.o:rooci.c:(.text+0x297): undefined reference to `OCIDateTimeSysTimeStamp'
    rooci.o:rooci.c:(.text+0x2ae): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x309): undefined reference to `OCIStmtExecute'
    rooci.o:rooci.c:(.text+0x355): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x3b2): undefined reference to `OCIBreak'
    rooci.o:rooci.c:(.text+0x3ca): undefined reference to `OCIReset'
    rooci.o:rooci.c:(.text+0x3fc): undefined reference to `OCIThreadIdInit'
    rooci.o:rooci.c:(.text+0x423): undefined reference to `OCIThreadHndInit'
    rooci.o:rooci.c:(.text+0x44d): undefined reference to `OCIThreadCreate'
    rooci.o:rooci.c:(.text+0x4b5): undefined reference to `OCIEnvCreate'
    rooci.o:rooci.c:(.text+0x4f3): undefined reference to `OCIClientVersion'
    rooci.o:rooci.c:(.text+0x53b): undefined reference to `OCIHandleFree'
    rooci.o:rooci.c:(.text+0x594): undefined reference to `OCIErrorGet'
    rooci.o:rooci.c:(.text+0x63d): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x67e): undefined reference to `OCIServerRelease'
    rooci.o:rooci.c:(.text+0x70c): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x7c9): undefined reference to `OCIHandleAlloc'
    rooci.o:rooci.c:(.text+0x814): undefined reference to `OCIStmtPrepare'
    rooci.o:rooci.c:(.text+0x859): undefined reference to `OCIStmtExecute'
    rooci.o:rooci.c:(.text+0x86b): undefined reference to `OCIHandleFree'
    rooci.o:rooci.c:(.text+0x89d): undefined reference to `OCITransCommit'
    rooci.o:rooci.c:(.text+0x8cd): undefined reference to `OCITransRollback'
    rooci.o:rooci.c:(.text+0x939): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0x99a): undefined reference to `OCIThreadIdInit'
    rooci.o:rooci.c:(.text+0x9e9): undefined reference to `OCIThreadJoin'
    rooci.o:rooci.c:(.text+0xa35): undefined reference to `OCIThreadHndInit'
    rooci.o:rooci.c:(.text+0xa69): undefined reference to `OCIThreadCreate'
    rooci.o:rooci.c:(.text+0xa84): undefined reference to `OCIBreak'
    rooci.o:rooci.c:(.text+0xaa2): undefined reference to `OCIReset'
    rooci.o:rooci.c:(.text+0xb3a): undefined reference to `OCIBindByPos'
    rooci.o:rooci.c:(.text+0xb75): undefined reference to `OCIBindArrayOfStruct'
    rooci.o:rooci.c:(.text+0xbbf): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0xc1c): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xd77): undefined reference to `OCIParamGet'
    rooci.o:rooci.c:(.text+0xdb3): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xdf6): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xe2e): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xe6c): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xf3b): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0xf71): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x107e): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x10cb): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x10ee): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x113e): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x1192): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x11eb): undefined reference to `OCIDescriptorAlloc'
    rooci.o:rooci.c:(.text+0x1260): undefined reference to `OCIDefineByPos'
    rooci.o:rooci.c:(.text+0x12bf): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0x134b): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x13f5): undefined reference to `OCIParamGet'
    rooci.o:rooci.c:(.text+0x1433): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x148b): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x14de): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x1532): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x1593): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x15db): more undefined references to `OCIAttrGet' follow

    rooci.o:rooci.c:(.text+0x16f0): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x174a): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x17ee): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x1864): undefined reference to `OCIParamGet'
    rooci.o:rooci.c:(.text+0x189e): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x18b0): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x1931): undefined reference to `OCIStmtFetch2'
    rooci.o:rooci.c:(.text+0x1991): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x19f9): undefined reference to `OCILobGetLength2'
    rooci.o:rooci.c:(.text+0x1acd): undefined reference to `OCILobRead2'
    rooci.o:rooci.c:(.text+0x1bd9): undefined reference to `OCILobGetLength2'
    rooci.o:rooci.c:(.text+0x1c73): undefined reference to `OCILobRead2'
    rooci.o:rooci.c:(.text+0x1d2a): undefined reference to `OCILobFileOpen'
    rooci.o:rooci.c:(.text+0x1d52): undefined reference to `OCILobFileClose'
    rooci.o:rooci.c:(.text+0x1ddc): undefined reference to `OCIDateTimeSubtract'
    rooci.o:rooci.c:(.text+0x1e1c): undefined reference to `OCIIntervalGetDaySecond'

    rooci.o:rooci.c:(.text+0x1f8f): undefined reference to `OCIIntervalSetDaySecond'

    rooci.o:rooci.c:(.text+0x1fbb): undefined reference to `OCIDateTimeIntervalAdd'
    rooci.o:rooci.c:(.text+0x1fe8): undefined reference to `OCIDateTimeIntervalAdd'
    rooci.o:rooci.c:(.text+0x2048): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x2101): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x22d0): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x243f): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x245d): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x2496): undefined reference to `OCIStmtRelease'
    rooci.o:rooci.c:(.text+0x24f0): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x2570): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x2630): undefined reference to `OCIDescriptorFree'
    rooci.o:rooci.c:(.text+0x2667): undefined reference to `OCISessionRelease'
    rooci.o:rooci.c:(.text+0x2683): undefined reference to `OCIHandleFree'
    rooci.o:rooci.c:(.text+0x269f): undefined reference to `OCIHandleFree'
    rooci.o:rooci.c:(.text+0x2772): undefined reference to `OCIHandleFree'
    rooci.o:rooci.c:(.text+0x28e5): undefined reference to `OCIHandleAlloc'
    rooci.o:rooci.c:(.text+0x2930): undefined reference to `OCIHandleAlloc'
    rooci.o:rooci.c:(.text+0x2980): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0x29c9): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0x2a4a): undefined reference to `OCISessionGet'
    rooci.o:rooci.c:(.text+0x2a84): undefined reference to `OCIServerVersion'
    rooci.o:rooci.c:(.text+0x2ae2): undefined reference to `OCIAttrSet'
    rooci.o:rooci.c:(.text+0x2b1c): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x2bb5): undefined reference to `OCINlsNumericInfoGet'
    rooci.o:rooci.c:(.text+0x2d6b): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x2dfb): undefined reference to `OCINlsCharSetConvert'
    rooci.o:rooci.c:(.text+0x2e4e): undefined reference to `OCIStmtPrepare2'
    rooci.o:rooci.c:(.text+0x2e9a): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x2ede): undefined reference to `OCIAttrGet'
    rooci.o:rooci.c:(.text+0x2f69): undefined reference to `OCIStmtPrepare2'
    rooci.o:rooci.c:(.text+0x2f85): undefined reference to `OCINlsCharSetNameToId'
    rooci.o:rooci.c:(.text+0x2fcc): undefined reference to `OCIStmtRelease'
    rooci.o:rooci.c:(.text+0x31af): undefined reference to `OCIDescriptorAlloc'
    collect2: ld returned 1 exit status
    installing to C:/Programmi/R/R-2.15.0/library/ROracle/libs/i386
    ** R
    ** inst
    ** preparing package for lazy loading
    ** help
    *** installing help indices
    ** building package indices
    ** installing vignettes
    ** testing if installed package can be loaded
    Error in library.dynam(lib, package, package.lib) :
    DLL 'ROracle' not found: maybe not installed for this architecture?
    Errore: loading failed
    Esecuzione interrotta
    ERROR: loading failed
    * removing 'C:/Programmi/R/R-2.15.0/library/ROracle'
    * restoring previous 'C:/Programmi/R/R-2.15.0/library/ROracle'
  • 3. Re: Unable to install ROracle_1.1-5 under Windows XP 32bit
    339359 Newbie
    Currently Being Moderated
    Hi Renato,

    I am not able to reproduce the problem you are facing. I tried it on Windows XP, here here is the output on my system:

    C:\Temp>instantclient-basic-nt-11.2.0.3.0.zip

    C:\Temp>instantclient-sdk-nt-11.2.0.3.0.zip

    C:\Temp>instantclient-sqlplus-nt-11.2.0.3.0.zip

    C:\Temp>set OCI_LIB32=c:\temp\instantclient_11_2

    C:\Temp>R CMD INSTALL --build ROracle_1.1-5.tar.gz
    * installing to library 'c:/R/R-2.15.1/library'
    * installing source package 'ROracle' ...
    ** package 'ROracle' successfully unpacked and MD5 sums checked
    looking for Instant Client c:/instantclient/i386/instantclient_11_2
    cygwin warning:
    MS-DOS style path detected: c:\temp\instantclient_11_2
    Preferred POSIX equivalent is: /cygdrive/c/temp/instantclient_11_2
    CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
    http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
    found Instant Client c:\temp\instantclient_11_2
    found Instant Client SDK c:\temp\instantclient_11_2/sdk/include
    copying from c:\temp\instantclient_11_2
    copying from c:\temp\instantclient_11_2/sdk/include
    ** libs
    Warning: this package has a non-empty 'configure.win' file,
    so building only the main architecture

    cygwin warning:
    MS-DOS style path detected: c:/r/R-2.15.1/etc/i386/Makeconf
    Preferred POSIX equivalent is: /cygdrive/c/r/R-2.15.1/etc/i386/Makeconf
    CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
    http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
    gcc -I"c:/r/R-2.15.1/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -m
    tune=core2 -c rodbi.c -o rodbi.o
    gcc -I"c:/r/R-2.15.1/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -m
    tune=core2 -c rooci.c -o rooci.o
    In file included from c:/r/R-2.15.1/include/R.h:44:0,
    from rodbi.h:37,
    from rooci.c:52:
    c:/r/R-2.15.1/include/R_ext/RS.h:43:0: warning: "ERROR" redefined [enabled by de
    fault]
    c:\rtools\gcc-4.6.3\bin\../lib/gcc/i686-w64-mingw32/4.6.3/../../../../i686-w64-m
    ingw32/include/wingdi.h:70:0: note: this is the location of the previous definit
    ion
    gcc -shared -s -static-libgcc -o ROracle.dll tmp.def rodbi.o rooci.o -Lc:\temp\i
    nstantclient_11_2 -loci -Lc:/r/R-2.15.1/bin/i386 -lR
    installing to c:/R/R-2.15.1/library/ROracle/libs/i386
    ** R
    ** inst
    ** preparing package for lazy loading
    ** help
    *** installing help indices
    ** building package indices
    ** installing vignettes
    ** testing if installed package can be loaded
    * MD5 sums
    packaged installation of 'ROracle' as ROracle_1.1-5.zip

    * DONE (ROracle)

    C:\Temp>version
    'version' is not recognized as an internal or external command,
    operable program or batch file.

    C:\Temp>ver

    Microsoft Windows XP [Version 5.1.2600]

    C:\Temp>R

    R version 2.15.1 (2012-06-22) -- "Roasted Marshmallows"
    Copyright (C) 2012 The R Foundation for Statistical Computing
    ISBN 3-900051-07-0
    Platform: i386-pc-mingw32/i386 (32-bit)

    R is free software and comes with ABSOLUTELY NO WARRANTY.
    You are welcome to redistribute it under certain conditions.
    Type 'license()' or 'licence()' for distribution details.

    Natural language support but running in an English locale

    R is a collaborative project with many contributors.
    Type 'contributors()' for more information and
    'citation()' on how to cite R or R packages in publications.

    Type 'demo()' for some demos, 'help()' for on-line help, or
    'help.start()' for an HTML browser interface to help.
    Type 'q()' to quit R.
    library("Roracle")
    Error in library("Roracle") : there is no package called 'Roracle'
    library("ROracle")
    Loading required package: DBI
    Oracle()
    Driver name: Oracle (OCI)
    Driver version: 1.1-5
    Client version: 11.2.0.3.0
    Connections processed: 0
    Open connections: 0
    Interruptible: FALSE
    >


    It seems to be a problem with oci.dll. What is the size of that dll?

    Thanks,
    ROracle Team

    Edited by: rpingte on Oct 10, 2012 2:45 PM
  • 4. Re: Unable to install ROracle_1.1-5 under Windows XP 32bit
    967637 Newbie
    Currently Being Moderated
    Hi,

    I have installed ROracle-1.1-5 on Windows XP 32 bit machine with R-2.15.0 and Rtools-2.15.
    My DBI version is 0.2-5 and OCI instant client version is 11.2.0.3.

    I did not face any issue during installation and using ROracle package.

    Please retry ROracle installation once again and let us know your observation.

    Steps followed to install ROracle package are :

    1) Download and install OCI instant client from (http://www.oracle.com/technetwork/topics/winx64soft-089540.html)
    http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
    2) Install Rtools from (http://cran.r-project.org/bin/windows/Rtools/)
    3) set path variables for R, Rtools & OCI instant client.
    4) set OCI_LIB32=<your IC path>


    --
    Thanks,
    ROracle Team.
  • 5. Re: Unable to install ROracle_1.1-5 under Windows XP 32bit
    962179 Newbie
    Currently Being Moderated
    Hi rpingte & ROracle Team,

    problem solved, library now installed, thank you!!

    I had just omitted one step: to set the variable OCI_LIB32 with

    set OCI_LIB32=c:\temp\instantclient_11_2

    I mistakenly thought, based on the installation instructions at

    http://cran.r-project.org/web/packages/ROracle/INSTALL

    that this step would not be necessary and that it would be sufficient to set ORACLE_HOME. The instructions indeed read:

    "If a different directory structure is used then environment variables can be used to specify the location of libraries and header files. OCI_LIB32 to specify the location of 32-bit libraries and OCI_LIB64 for 64-bit libraries."

    I did not use a different directory structure and I was in fact able to install the previous version ROracle 1.1-4 without setting OCI_LIB32. Anyway, all is well that ends well, so once again thank you very much for your help and kind regards.

    Renato

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points