2 Replies Latest reply: May 23, 2013 8:59 AM by DWisker RSS

    RORacle Install Issue on Windows 7

    DWisker
      Attempt to install ROracle 1.1-10 gets the following (I have included all of the relevant commands and results I could think of):


      ****************************************************************************************
      **set OCI_INC=D:\oracle\product\11.1.0\client_1\oci\include**
      **set OCI_LIB32=D:\oracle\product\11.1.0\client_1\bin**

      **PATH=c:\Rtools\bin;c:\Rtools\gcc-4.6.3\bin;c:\Program Files\R\R-2.15.3\bin**

      **c:\Program Files\R\R-2.15.3\bin>R CMD INSTALL DBI_0.2-7.tar.gz**
      *** installing to library 'c:/Program Files/R/R-2.15.3/library'**
      *** installing source package 'DBI' ...**
      **** package 'DBI' successfully unpacked and MD5 sums checked**
      **** R**
      **** inst**
      **** preparing package for lazy loading**
      **Creating a generic function for 'summary' from package 'base' in package 'DBI'**
      **** help**
      ***** installing help indices**
      **** building package indices**
      **** installing vignettes**
      **'DBI.Rnw'**
      **** testing if installed package can be loaded**

      *** DONE (DBI)**

      **c:\Program Files\R\R-2.15.3\bin>R CMD INSTALL ROracle_1.1-10.tar.gz**
      *** installing to library 'c:/Program Files/R/R-2.15.3/library'**
      *** installing source package 'ROracle' ...**
      **** package 'ROracle' successfully unpacked and MD5 sums checked**
      **cygwin warning:**
      **MS-DOS style path detected: D:\oracle\product\11.1.0\client_1\bin**
      **Preferred POSIX equivalent is: /cygdrive/d/oracle/product/11.1.0/client_1/bin**
      **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**
      **ERROR: cannot find D:\oracle\product\11.1.0\client_1\bin/sdk/include or Oracle C**
      **lient include.**
      **Please set OCI_INC to specify its location.**
      **ERROR: configuration failed for package 'ROracle'**
      *** removing 'c:/Program Files/R/R-2.15.3/library/ROracle'**
      ***************************************************************

      The path I set is correct, as far as I can tell.
        • 1. Re: RORacle Install Issue on Windows 7
          Rpingte-Oracle
          Hi,

          I tried the same steps on my Windows 7 desktop and did not see any issues:
          set OCI_INC=C:\app\rpingte\product\11.2.0\client_2\oci\include
          set OCI_LIB32=C:\app\rpingte\product\11.2.0\client_2\bin
          PATH on my machine: c:\Rtools\bin;c:\Rtools\gcc-4.6.3\bin;C:\app\rpingte\product\11.2.0\client_2\bin;...c:\R\R-2.15.1\bin\i386;

          C:\temp>R CMD INSTALL ROracle_1.1-10.tar.gz
          * installing to library 'c:/R/R-2.15.1/library'
          * installing source package 'ROracle' ...
          cygwin warning:
          MS-DOS style path detected: C:\app\rpingte\product\11.2.0\client_2\bin
          Preferred POSIX equivalent is: /cygdrive/c/app/rpingte/product/11.2.0/client_2/bin
          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
          Oracle Client Shared Library 32-bit - 11.2.0.1.0 Operating in ORACLE_HOME environment.
          found Oracle Client C:\app\rpingte\product\11.2.0\client_2\bin
          found Oracle Client include C:\app\rpingte\product\11.2.0\client_2\oci\include
          copying from C:\app\rpingte\product\11.2.0\client_2\oci\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 -mtune=core2 -c rodbi.c -o rodbi.o
          gcc -I"c:/R/R-2.15.1/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -mtune=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:60:
          c:/R/R-2.15.1/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 definit
          ion
          gcc -I"c:/R/R-2.15.1/include" -DNDEBUG -I./oci -O3 -Wall -std=gnu99 -mtune=core2 -c routl.c -o routl.o
          routl.c: In function 'InCharMem':
          routl.c:258:1: warning: no return statement in function returning non-void [-Wreturn-type]
          routl.c: In function 'unserializeCall':
          routl.c:332:1: warning: control reaches end of non-void function [-Wreturn-type]

          routl.c: In function 'serializeCall':
          routl.c:92:19: warning: 'colvec' may be used uninitialized in this function [-Wuninitialized]
          routl.c:62:23: note: 'colvec' was declared here
          gcc -shared -s -static-libgcc -o ROracle.dll tmp.def rodbi.o rooci.o routl.o C:\app\rpingte\product\11.2.0\client_2\bin/oci.dll -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

          * DONE (ROracle)

          Is the oci\include directory present on your system? Also, install should display something like the following:
          ...
          Oracle Client Shared Library 32-bit - 11.2.0.1.0 Operating in ORACLE_HOME environment.
          found Oracle Client C:\app\rpingte\product\11.2.0\client_2\bin
          found Oracle Client include C:\app\rpingte\product\11.2.0\client_2\oci\include
          copying from C:\app\rpingte\product\11.2.0\client_2\oci\include
          ...
          • 2. Re: RORacle Install Issue on Windows 7
            DWisker
            I realized, after looking at your PATH command, that I had left two items out. I put them in and the install ran flawlessly. Many thanks!