5 Replies Latest reply: Oct 11, 2012 11:08 AM by 962179 RSS

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

    962179
      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
          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
            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
              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
                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
                  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