title: R and database Roracle
body: <p>I am using <strong>Rstudio</strong> (or R) with the package ROracle to connect to db. However I have the following error message</p>
  
  <pre><code>Error in .oci.Connect(.oci.drv(), username = username, password = password,  : 
  ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>
  
  <p>One possible solution is to add the following line to the <code>.Renviron</code> file. But I guess my R does not read this file. How can I be sure, or force R to read <code>.Renviron</code>? (I am using Windows.)</p>
  
  <p>Some other suggestion from Oracle are <a href="http://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm" rel="nofollow">here</a>.</p>
  
  <p>I am so grateful for every hint.</p>