Rstudio Server and ROracle
998747Mar 23 2013 — edited Apr 4 2013I have problem using ROracle with RStudio Server. dbDriver('Oracle') load fine but when i tried to connect using dbConnect() i always get following errors
Error in .oci.Connect(.oci.drv(), username = username, password = password, :
ORA-12154: TNS:could not resolve the connect identifier specified
Everything works fine when I use desktop version of RStudio. I tried to add ORACLE_HOME and ORACLE_SID variables to .Renviron but it didn't help.
Hope someone can help me with this problem :)