如何在R 4.1.3上安装ROracle

Question

我正试图在RStudio中安装ROracle包，以便将R连接到我的Oracle数据库。我下载了zip文件，但当我运行时

remotes::install_local("ROracle_1.3-2.tar.gz", repos = NULL, type = "source")

我得到一个错误：

ERROR: cannot find Oracle Client. Please set OCI_LIB64 to specify its location.

我的电脑上确实安装了Oracle客户端。这可能是一个显而易见的答案，但我的问题是，我如何设置OCI_LB64来识别Oracle Client在电脑上的位置。我运行的是windows 10和R版本4.1.3。

Answer 1

查看安装指南。对于窗口，它有以下步骤：

13.Add the full path of the Instant Client to the environment variables 
OCI_LIB64 and PATH. 
The following steps set the variables to the PATH used in this example, 
c:myoreclientinstantclient_11_2. 
1. In Windows Control Panel, select System, then click Advanced system 
settings.
2. On the Advanced tab, click Environment Variables. 
3. Under System variables, create OCI_LIB64 if it does not already exist. 
4. Set the value of OCI_LIB64 to c:oreclientinstantclient_11_2. 
5. Under System variables, edit PATH to include 
c:oreclientinstantclient_11_2.