This content has been marked as final. Show 4 replies
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
Thanks!!! You made my day :)
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!