RStudio server ROracle throw: error in .oci.Driver (): internal error ROracle [rociDrvInit, 1, -1]

I installed RStudio server and instructed it to use an existing R installation (2.13). ROracle works fine when accessed from R, but the same does not work with RStudio web interface.

> library(ROracle)

Loading required package: DBI

> drv <- dbDriver("Oracle")

Error in .oci.Driver (): ROracle internal error [rociDrvInit, 1, -1]

I installed an RStudio server with --nodeps and later pointed it to an existing R installation by setting values ​​in the /etc/rstudio/rserver.conf file.

Tried getting help from RStudio support but was directed towards Stack Overflow. http://support.rstudio.org/help/discussions/problems/1879-rstudio-roracle-internal-error

Thanks in advance, Sai.

+3


source to share


1 answer


Finally, he worked with the help of Denis Mukhin on the Oracle forums . In particular, the RStudio environment lacked ORACLE_HOME

and OREACLE_SID

. Adding the following lines to the ~/.Renviron

fixed:



ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
ORACLE_SID=<your sid (the default is usually orcl)>
export ORACLE_HOME ORACLE_SID

      

+1


source







All Articles