Tag Archives: Oracle

Python – cx_Oracle throws missing libclntsh.so.11.1 when executed by django-chronograph

I have setup the cx_Oracle and i could query the data thru the custom django-admin command.

 

But when i try to schedule the custom command using django-chronograph. It throws the following error.

Traceback (most recent call last):
  File "query.py", line 7, in ?
    import cx_Oracle
ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Continue reading Python – cx_Oracle throws missing libclntsh.so.11.1 when executed by django-chronograph

Python – Install cx_Oracle

I want to query data from an Oracle database from a Python program and this could be done by using the cx_Oracle Python package. This package required some Oracle package pre-requisites so it cannot be installed thru pip directly.

The following steps are done on a Centos 7 machine with Python 2.7.

1. Download and install the following from Oracle.

  • oracle-instantclient11.2-basic
  • oracle-instantclient11.2-devel
  • oracle-instantclient11.2-sqlplus

 

2. The installed client should be located at /usr/lib/oracle/11.2/client64.
Continue reading Python – Install cx_Oracle