How to fix: cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library - Python : <p>I am establishing a connection to oracle 11g which is in a remote server using cx_oracle 7 with python 3.6.7. my OS in Ubuntu 18.04</p>

<p>I have installed oracle instant client library with libclntsh.so but I am not getting the expected output.</p>

<p>here is the code which i am using to connect to the oracle db</p>

<pre><code>connection = cx_Oracle.connect("username/password@host/port")
print (connection.version)
connection.close()
</code></pre>

<p>when the script runs i expect to get the connection version instead i am getting the following error message</p>

<blockquote>
  <p>File "script.py", line 13, in 
      connection = cx_Oracle.connect("username/password@host/port") cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle
  Client library: "libclntsh.so: cannot open shared object file: No such
  file or directory". See
  <a href="https://oracle.github.io/odpi/doc/installation.html#linux" rel="noreferrer">https://oracle.github.io/odpi/doc/installation.html#linux</a> for help</p>
</blockquote>
