我正在尝试在 Windows 7 客户端上安装 ROracle 包。我安装了 Oracle Instant 客户端和 Rtools,安装了 DBI 包,设置了 OCI32_LIB 环境变量。但是当我尝试从命令行安装时:
C:\Temp>R CMD INSTALL --build ROracle_1.1-10.tar.gz
* installing to library 'C:/Users/myaccount/Documents/R/win-library/3.0'
* installing *source* package 'ROracle' ...
** package 'ROracle' successfully unpacked and MD5 sums checked
ERROR: configuration failed for package 'ROracle'
* removing 'C:/Users/myaccount/Documents/R/win-library/3.0/ROracle'
C:\Temp>
当我尝试从源安装时:
> install.packages("ROracle",type = "source")
Warning in install.packages :
package ‘ROracle’ is not available (for R version 3.0.0)
Installing package into ‘C:/Users/myaccount/Documents/R/win-library/3.0’
(as ‘lib’ is unspecified)
trying URL 'http://cran.at.r-project.org/src/contrib/ROracle_1.1-10.tar.gz'
Content type 'application/x-gzip' length 168193 bytes (164 Kb)
opened URL
downloaded 164 Kb
* installing *source* package 'ROracle' ...
** package 'ROracle' successfully unpacked and MD5 sums checked
ERROR: configuration failed for package 'ROracle'
* removing 'C:/Users/myaccount/Documents/R/win-library/3.0/ROracle'
Warning in install.packages :
running command '"C:/PROGRA~1/R/R-30~1.0/bin/i386/R" CMD INSTALL -l "C:\Users\myaccount\Documents\R\win-library\3.0" C:\Users\myaccount\AppData\Local\Temp\RtmpGggbyp/downloaded_packages/ROracle_1.1-10.tar.gz' had status 1
Warning in install.packages :
installation of package ‘ROracle’ had non-zero exit status
The downloaded source packages are in
‘C:\Users\myaccount\AppData\Local\Temp\RtmpGggbyp\downloaded_packages’
我应该做什么,如何进行?
From http://jgilfillan.github.io/2016/05/28/how-to-install-roracle-in-windows-7/ http://jgilfillan.github.io/2016/05/28/how-to-install-roracle-in-windows-7/
从 oracle 下载二进制文件:http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html
在 r 中运行以下命令,替换文件路径:
setwd('xxxxx') # set to path of download
install.packages('ROracle_1.2-1.zip', repos = NULL)
然后加载库并使用该包 - 您可能需要将 XXXX 更改为 TNS 名称中的任何内容:
library('ROracle')
drv <- dbDriver("Oracle")
con <- dbConnect(drv, "USER GOES HERE", "PASSWORD GOES HERE", dbname='XXX')
测试连接:
dbReadTable(con, 'DUAL')
请注意,这也已被证实适用于 Windows 10。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)