title: How to Connect Oracle SQL Database using R language in Google Colab
body: <p>I am new to R and Google Colab. Am unable to connect Oracle Database in Google Colab using R. followed this link : <a href="https://guillaumepressiat.github.io/blog/2019/11/oraclyr" rel="nofollow noreferrer">https://guillaumepressiat.github.io/blog/2019/11/oraclyr</a></p>
  <pre><code>library(odbc)
  library(dplyr)
  library(dbplyr)
  library(lubridate)
  con&lt;-DBI::dbConnect(odbc::odbc(), Driver=&quot;Oracle in instantclient_12_2&quot;, Host=&quot;###&quot;, SVC=&quot;###&quot;, UID=&quot;###&quot;, PWD=&quot;###&quot;, Port=&quot;###&quot;)
  </code></pre>
  <p>on running above statements thrown an error :</p>
  <blockquote>
  <p>Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'Oracle in instantclient_12_2' : file not found
  Traceback:</p>
  </blockquote>
  <p>Please help me how to connect Colab with Oracle Databases using R.</p>