Linux下安装ROracle包

1.下载oracle client

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

 

2.安装oracle client

[root@hadoop2 ~]# rpm -ivhoracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

Preparing...               ########################################### [100%]

  1:oracle-instantclient11.###########################################[100%]

[root@hadoop2 ~]# rpm -ivhoracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

Preparing...               ########################################### [100%]

  1:oracle-instantclient11.###########################################[100%]

  

3.下载ROracle 包

https://cran.r-project.org/web/packages/ROracle/index.html

ROracle_1.2-2.tar.gz

 

4.设置环境变量

# vi ~/.bash_profile

exportLD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

 

注：如果没有设置环境变量，在下一步安装ROracle包时，会出现下面的错误：

** building package indices

** testing if installed packagecan be loaded

Error in dyn.load(file, DLLpath= DLLpath, ...) :

  无法载入共享目标对象‘/usr/lib64/R/library/ROracle/libs/ROracle.so’：:

  libclntsh.so.11.1: 无法打开共享对象文件: 没有那个文件或目录

错误: 载入失败

停止执行

ERROR: loading failed

5.安装DBI包

R

>install.packages(“DBI”)

6.安装ROracle 包

# 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.2-2.tar.gz

......

** building package indices

** testing if installed package can beloaded

* DONE (ROracle)

Making 'packages.html' ... 好了

Windows下ROracle安装及使用：

http://blog.csdn.net/lichangzai/article/details/40736777