[问题类型]:
经验咨询(我想用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
麻烦高人解惑～不知道是哪个环节问题