title: sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library
body: <p>We have an oracle database and i am trying to connect to oracle database using python in linux. We have installed "sqlalchemy" , "cx_Oracle" libraries. </p>
  
  <p>When i try to execute the below python script, i am getting below error.</p>
  
  <pre><code>Error: sqlalchemy.exc.DatabaseError: (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 
  https://oracle.github.io/odpi/doc/installation.html#linux for help
  (Background on this error at: http://sqlalche.me/e/4xp6)
  </code></pre>
  
  <p>Is there any way without installing "Instant Client" , i can connect to oracle database and execute .... ? </p>
  
  <p>Please help me with any suggestion</p>
  
  <p>Below is the code. </p>
  
  <pre><code>import sqlalchemy
  from sqlalchemy import types,create_engine
  
  conn = create_engine('oracle://User:password@hostname:1521/?service_name=ABCD') 
  
  cur = conn
  
  ABC = []
  
  select = cur.execute("select EMPLOYEE_ID,EMPLOYEE_NAME from EMPLOYEE") 
  for line in select:
      ABC.append(line)
  
  print(ABC)
  </code></pre>