This discussion is archived
2 Replies Latest reply: May 23, 2013 6:59 AM by DWisker RSS

RORacle Install Issue on Windows 7

DWisker Newbie
Currently Being Moderated
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
    339359 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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!

Legend

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