作者giock18 (小武)
看板R_Language
标题[问题] Roracle安装问题
时间Fri Apr 21 11:49:55 2017
[问题类型]:
经验谘询(我想用R 连接某些资料库，请问大家的经验)
[软体熟悉度]:
新手(没写过程式，R 是我的第一次)
[问题叙述]:
依据版大的建议想要使用Roracle的套件，但安装失败，环境变数都已经设定了
还是有错误讯息，想请叫大家该怎麽修改？
首先说明一下我相关的环境变数
PATH=
C:\oracle\product\12.1.0\client_1\bin;
c:\Rtools\bin;
c:\Rtools\mingw_32\bin;
C:\ProgramData\Oracle\Java\javapath;
C:\Program Files\R\R-3.3.3\bin
OCI_LIB64=C:\oracle\product\12.1.0\client_1\bin
OCI_INC=C:\oracle\product\12.1.0\client_1\sdk\include (oci.h在这目录下)
[程式范例]:
install.packages("ROracle",type = "source")
错误讯息如下：
trying URL '
https://cran.rstudio.com/src/contrib/ROracle_1.3-1.tar.gz'
Content type 'application/x-gzip' length 308252 bytes (301 KB)
downloaded 301 KB
* installing *source* package 'ROracle' ...
** package 'ROracle' successfully unpacked and MD5 sums checked
ERROR: cannot find Oracle Client.
Please set OCI_LIB64 to specify its location.
Warning: 执行中命令 'sh ./configure.win' 已有状态 1
ERROR: configuration failed for package 'ROracle'
* removing 'C:/Program Files/R/R-3.3.3/library/ROracle'
Warning in install.packages :
running command '"C:/PROGRA~1/R/R-3.3.3/bin/x64/R" CMD INSTALL -l
"C:\Program Files\R\R-3.3.3\library"
C:\Users\myID\AppData\Local\Temp\RtmpCYB3hn/downloaded_packages/ROracle_1.3-1.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\myID\AppData\Local\Temp\RtmpCYB3hn\downloaded_packages’
[环境叙述]:
R version 3.3.3 (2017-03-06)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
locale:
[1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 LC_CTYPE=Chinese
(Traditional)_Taiwan.950
[3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 LC_NUMERIC=C
[5] LC_TIME=Chinese (Traditional)_Taiwan.950
attached base packages:
[1] stats graphics grDevices utils datasets methods base
loaded via a namespace (and not attached):
[1] tools_3.3.3
[关键字]:
Roracle、windows7
麻烦高人解惑～不知道是哪个环节问题
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 60.250.53.249
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1492746599.A.628.html