[R-sig-DB] RStudio Server ROracle internal error

[Denis Mukhin]

Sai,

You are probably missing ORACLE_HOME and OREACLE_SID in the RStudio environment. Try creating ~/.Renviron and put the following in it:
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

Denis

-----Original Message-----
From: Sai Munikuntla [mailto:SMunikuntla using recomdata.com] 
Sent: Thursday, March 15, 2012 11:32 AM
To: r-sig-db using r-project.org
Subject: [R-sig-DB] RStudio Server ROracle internal error

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.

>library(ROracle)

Loading required package: DBI
>Oracle()

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

"/etc/rstudio/rserver.conf" has rsession-which-r=/usr/local/R/bin/R
rsession-ld-library-path=/u01/app/oracle/product/11.1.0/db_1/lib:/u01/app/oracle/product/11.1.0/db_1

There is an existing path environment variable defined $ env |grep LD_LIB* =/u01/app/oracle/product/11.1.0/db_1/lib:/u01/app/oracle/product/11.1.0/db_1

RStudio web-interface was giving me the above mentioned issue. I added the path in rserver.conf and restarted the RStudio server but the problem still exists.


	[[alternative HTML version deleted]]

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group R-sig-DB using r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db