title: docker run error : DPI-1047: Cannot locate a 64-bit Oracle Client library
body: <p>I am trying to dockerize a very simple python application with Oracle database connection and execute it on Docker. This application is executing fine on my local machine.</p>
  <p>I was successfully able to build this application but getting an error while executing it on Docker.</p>
  <p><em><strong>DockerFile:</strong></em></p>
  <pre><code>FROM python:3
  
  ADD File.py /
  
  RUN pip install cx_Oracle
  RUN pip install pandas
  RUN pip install openpyxl
  
  CMD [ &quot;python&quot;, &quot;./File.py&quot; ]
  </code></pre>
  <p><em><strong>File.py:</strong></em></p>
  <pre><code>import cx_Oracle
  import pandas as pd
  
  #creating database connection
  dsn_tns = cx_Oracle.makedsn('dev-tr01.com', '1222', service_name='ast041.com')
  conn = cx_Oracle.connect(user=r'usr', password='3451', dsn=dsn_tns)
  c = conn.cursor()
  
  query ='SELECT * FROM Employee WHERE ROWNUM &lt;10'
  result = pd.read_sql(query, con=conn)
  result.to_excel(&quot;batchtable.xlsx&quot;)
  
  conn.close()
  </code></pre>
  <p><em><strong>Error:</strong></em></p>
  <blockquote>
  <p>docker run python_batchdriver:latest</p>
  <p>cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: &quot;libclntsh.so: cannot open shared object file: No such file or directory&quot;. See <a href="https://oracle.github.io/odpi/doc/installation.html#linux" rel="nofollow noreferrer">https://oracle.github.io/odpi/doc/installation.html#linux</a> for help</p>
  </blockquote>