title: Unable to connect to Oracle database using R
body: <p>I am unable to make a connection to Oracle Database using R Studio.</p>
  
  <p>Below are the codes that I have executed to set up the connection.</p>
  
  <pre><code>library(RJDBC)
  
  1. jdbcDriver =JDBC("oracle.jdbc.OracleDriver",classPath="C:/Users/abc/Downloads/ojdbc6.jar")
  </code></pre>
  
  <p>Above code was successfully executed.</p>
  
  <p>I get an error in the below code.</p>
  
  <pre><code>jdbcConnection =dbConnect(jdbcDriver, "jdbc:oracle:data:@//20.666.1.66:1521/lifedata", 
                            user="abc", password="def")
  </code></pre>
  
  <blockquote>
    <p>Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  : 
      java.sql.SQLException: Invalid Oracle URL specified</p>
  </blockquote>
  
  <p>My R version is 3.4.0</p>