ROracle安装

Question

我很难让ROracle包在我的电脑上运行。我有windows 10和R3.5.1(它在windows 7上工作)。第一次尝试：

install.packages("ROracle")
Installing package into 
‘C:/Users/Documents/R/win-library/3.5’
(as ‘lib’ is unspecified)
Package which is only available in source form, and may need compilation of 
C/C++/Fortran: ‘ROracle’
These will not be installed

我按照这里的说明，直接从甲骨文How to install ROracle package on Windows 7?下载它

我也看了这些网站，但这些建议也不起作用。How to install ROracle package?

ROracle installation :: Unable to load shared object error

how to install r package for oracle on windows 10 64 bit

setwd("C:\\Users\\Downloads")
install.packages('ROracle_1.3-1.zip', repos = NULL)
Installing package into ‘C:/Users/Documents/R/win-library/3.5’
   (as ‘lib’ is unspecified)
   package ‘ROracle’ successfully unpacked and MD5 sums checked

library(ROracle)
Error: package or namespace load failed for ‘ROracle’:
package ‘ROracle’ was installed by an R version with different internals; it 
needs to be reinstalled for use with this R version

我的机器上有mysql和sqldeveloper。任何帮助都将不胜感激。

Answer 1

下载兼容ROracle、即时客户端和R的版本

RTools的最新版本可以从下面的链接下载

重要链接：即时客户端版本(12.2)：下载即时客户端http://www.oracle.com/technetwork/database/features/instant-client/的基本以及sdk版本

R for Windows (查找R for Windows的早期版本) https://cran.rstudio.com/bin/windows/base/old/ https://cran.rstudio.com/bin/windows/base/old/3.6.1/R-3.6.1-win.exe

RTools (RTools35) https://cran.r-project.org/bin/windows/Rtools/

ROracle (ROracle-1.3.2与R3.6.0版本及更高版本兼容) https://www.oracle.com/database/technologies/roracle-downloads.html是ROracle：https://cran.cnr.berkeley.edu/web/packages/ROracle/INSTALL故障排除的重要链接

RStudio

在控制面板> System & Security >系统属性中的System>高级系统Settings>中设置以下环境变量，单击以下设置的“环境变量”>系统变量：

ORACLE_HOME = 'C:/oreclient_install_dir/instantclient_12_2'
OCI_INC     = 'C:/oreclient_install_dir/instantclient_12_2/sdk/include'
OCI_LIB64   = 'C:/oreclient_install_dir/instantclient_12_2'
TNS_ADMIN   = 'C:/oreclient_install_dir/instantclient_12_2'

请参阅我已经安装了64位版本的R，因此设置环境变量的相同。如果您使用的是32位版本，请使用适当的路径设置OCI_LIB32 .另外，将TNS文件放置在适当的位置。

此外，将路径设置为包括：

C:\oreclient_install_dir\instantclient_12_2 <br/>
C:\app\client\pc_username\product\12.2.0\client_1  
C:\app\client\pc_username\product\12.2.0\client_1\bin  
C:\app\client\pc_username\product\12.2.0\client_1\Network\Admin  
%PATH%
C:\R\R-3.6.0\bin  
C:\R\Rtools\bin  
C:\R\Rtools\mingw_64\bin  

很少有重要的R命令来检查变量集：

R.home(component = "home")
Sys.getenv("PATH")
Sys.getenv("OCI_INC")
Sys.getenv("OCI_LIB64")
Sys.getenv("ORACLE_HOME")
Sys.getenv("TNS_ADMIN")

请在设置env变量时重新启动R，并建议在运行ROracle命令时以管理员身份运行R。

install.packages("C:/ROracle/ROracle_1.3-2.tar.gz"，repos = NULL)

您可能还需要安装DBI包。

install.packages("DBI")
library("DBI")
library("ROracle")