Skip to content

ROracle package

3 messages · José Luis Cañadas, Paul Gilbert

#
Hello everybody.

I'm a newbie in R in a debian and linux in general

I'm trying install roracle in my debian 64 bit system. I've read the
http://cran.r-project.org/web/packages/ROracle/INSTALL and I've
installed Oracel Instant Client by rpm package (using alien to deb convert).

When I try to install I write

  export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:$LD_LIBRARY_PATH


in terminal and then I download ROracle_1.1-1.tar.gz from cran and I
type sudo R CMD INSTALL ROracle_1.1-1.tar.gz where I've downloaded the
tar.gz file.

I always get the same error
jose at jose-laptop:~/Descargas$ sudo R CMD INSTALL ROracle_1.1-1.tar.gz
* installing to library ?/usr/local/lib/R/site-library?
* installing *source* package ?ROracle? ...
** package ?ROracle? successfully unpacked and MD5 sums checked
configure: error: OCI libraries not found
ERROR: configuration failed for package ?ROracle?
* removing ?/usr/local/lib/R/site-library/ROracle?

and I don't understand why. any idea?

Thanks.

PD: Really I need install ROracle for my job. please help me ;)
#
Jose

I have not installed on your platform, but when you gunzip and untar the 
.gz there are some pointers in the INSTALL file that may be helpful, 
including:

   When installing Instant Client from a ZIP package you will still need 
to set
   LD_LIBRARY_PATH but additionally you will need to specify the location of
   Oracle Client libraries and header files via either an environment 
variable
   OCI_LIB or a configure option --with-oci-lib. For example, if using an
   environemnt variable

   export OCI_LIB=/scratch/instantclient_11_2

and a few other suggestions that may help.

Paul
On 12-03-06 04:22 PM, jose luis ca?adas wrote:
#
Don't worry. Denis Mukhin (author of package) gives me a solution.
Consists in instead of R CMD INSTALL "name of package" use

R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/11.2/client64/lib --with-oci-inc=/usr/include/oracle/11.2/client64' ROracle_1.1-1.tar.gz

and maybe copy (at least for me) copy or link  lib files on
/usr/lib/oracle/11.2/client64/lib  to /usr/lib and then use

R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/11.2/client64/lib --with-oci-inc=/usr/include/oracle/11.2/client64' ROracle_1.1-1.tar.gz


Anyway, thanks you. I've learned so much about my linux system today.
El 06/03/12 23:51, Paul Gilbert escribi?: