Rstudio连接虚拟机（远程）oracle数据库

1)下载instantclient-basic-win-x86-64-11.2.0.1.0.zip和instantclient-sdk-win-x86-64-11.2.0.1.0.zip，解压至目录D:\oreclient\instantclient_11_2，可自定义目录。

2)安装Rtool，安装好后将c:\Rtools\bin和c:\Rtools\mingw_64\bin添加至Path环境变量。

3)将D:\oreclient\instantclient_11_2添加至系统环境变量OCI_LIB64和 PATH，先安装DBI包，再用网络安装方式安装ROracle。

4)Rstudo连接oracle。举例：

library(ROracle)

drv <- dbDriver("Oracle")

connect_str <-("(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.1)(PORT = 1521))) (CONNECT_DATA = (SERVER =DEDICATED)(SERVICE_NAME = orcl)))")

conn <- dbConnect(drv,username ="system",password = "manager",dbname = connect_str)

mdata <- dbSendQuery(conn,"select *from table1")

d<-fetch(mdata)

dbDisconnect(conn)

注意：如果不成功试试将R的安装路径添加到环境变量Path中，如我用的是Microsoft R Open 3.4.4：

C:\Program Files\Microsoft\R Open\R-3.4.4\bin\x64