4 Replies Latest reply: Jun 15, 2012 3:39 PM by Sherry Lamonica-Oracle RSS

    RStudio Server ROracle internal error

    604593
      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*
      LD_LIBRARY_PATH=/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 /etc/rstudio/rserver.conf and restarted the RStudio server but the problem still exists.