I've setup RStudio server and pointed it to use an existing R (2.13) installation. ROracle works fine when accessed from R, but the same does not work from RStudio web-interface.
Loading required package: DBI
Error in .oci.Driver() : ROracle internal error [rociDrvInit, 1, -1]
"/etc/rstudio/rserver.conf" has rsession-which-r=/usr/local/R/bin/R
There is an existing path environment variable defined
$ env |grep LD_LIB*
RStudio web-interface was giving me the above mentioned issue. I added the path in /etc/rstudio/rserver.conf and restarted the RStudio server but the problem still exists.
You are probably missing ORACLE_HOME and OREACLE_SID in the RStudio environment. Try creating ~/.Renviron and put the following in it:
ORACLE_SID=<your sid (the default is usually orcl)>
export ORACLE_HOME ORACLE_SID
I have a similar problem, except that:
- I get this error in both R and RStudio
- R version 2.14
- I am on Windows x64
I see what is suggested above, but I don't understand what these variables are supposed to be pointing at.
Edited by: user10467751 on Jun 7, 2012 1:47 PM
ORACLE_HOME is an environment variable pointing to the directory where the Oracle software is installed. The Oracle System ID (SID) is used to uniquely identify a particular database on a system. Users can set the ORACLE_SID environment variable to work on a particular database. If you don't know the correct path to use for ORACLE_HOME or the value for the SID, try checking with your DBA or Systems Administrator. Hope it helps!