install cx oracle for python

Question

Am on Debian 5  I ve been trying to install cx oracle module for python without any success  First  I installed oracle-xe-client and its dependency  followed tutorial in the following link here     Then  I used the scripts in  usr lib oracle xe app oracle product 10 2 0 client bin to populate environment variables such as PATH  ORACLE HOME and NLS LANG   Once  this was completed  I tried to run   sudo easy install cx oracle   But I keep getting the following error   Searching for cx-oracle Reading http   pypi python org simple cx oracle  Reading http   cx-oracle sourceforge net Reading http   starship python net crew atuining Best match  cx-Oracle 5 0 4 Downloading http   prdownloads sourceforge net cx-oracle cx Oracle-5 0 4 tar gz download Processing cx Oracle-5 0 4 tar gz Running cx Oracle-5 0 4 setup py -q bdist egg --dist-dir  tmp easy install-xsylvG cx Oracle-5 0 4 egg-dist-tmp-8KoqIx error  cannot locate an Oracle software installation   Any idea what I missed here

User · Answer

This just worked for me on Ubuntu 16  Download   instantclient-basic-linux x64-12 2 0 1 0 zip  and  instantclient-sdk-linux x64-12 2 0 1 0 zip   from Oracle web site and then do following script  you can do piece by piece and I did as a ROOT    apt-get install -y python-dev build-essential libaio1 mkdir -p  opt ora  cd  opt ora      Now put 2 ZIP files      instantclient-basic-linux x64-12 2 0 1 0 zip  and  instantclient-sdk-linux x64-12 2 0 1 0 zip      into  opt ora  and unzip them - gt  both will be unzipped into 1 directory   opt ora instantclient 12 2   rm -rf  etc profile d oracle sh echo  export ORACLE HOME  opt ora instantclient 12 2    gt  gt   etc profile d oracle sh echo  export LD LIBRARY PATH  LD LIBRARY PATH  ORACLE HOME    gt  gt   etc profile d oracle sh chmod 777  etc profile d oracle sh source  etc profile d oracle sh env   grep -i ora    This will check current ENVIRONMENT settings for Oracle   rm -rf  etc ld so conf d oracle conf echo   opt ora instantclient 12 2   gt  gt   etc ld so conf d oracle conf ldconfig cd  ORACLE HOME   ls -lrth libclntsh      This will show which version of  libclntsh  you have    -- gt  needed for following line   ln -s libclntsh so 12 1 libclntsh so  pip install cx Oracle     Maybe not needed but I did it anyway  only pip install cx Oracle without above steps did not work for me       Your python scripts are now ready to use  cx Oracle     Enjoy

User · Answer

Alternatively you can install the cx Oracle module without the PIP using the following steps   Download the source from here https   pypi python org pypi cx Oracle  cx Oracle-6 1 tar gz   Extract the tar using the following commands  Linux   gunzip cx Oracle-6 1 tar gz  tar -xf cx Oracle-6 1 tar cd cx Oracle-6 1 Build the module  python setup py build Install the module  python setup py install

User · Answer

The alternate way  that doesn t require RPMs  You need to be root    Dependencies  Install the following packages   apt-get install python-dev build-essential libaio1  Download Instant Client for Linux x86-64  Download the following files from Oracle s download site    Extract the zip files  Unzip the downloaded zip files to some directory  I m using     opt ora   Add environment variables  Create a file in  etc profile d oracle sh that includes  export ORACLE HOME  opt ora instantclient 11 2 export LD LIBRARY PATH  LD LIBRARY PATH  ORACLE HOME   Create a file in  etc ld so conf d oracle conf that includes   opt ora instantclient 11 2   Execute the following command  sudo ldconfig   Note  you may need to reboot to apply settings Create a symlink  cd  ORACLE HOME  ln -s libclntsh so 11 1 libclntsh so  Install cx Oracle python package   You may install using pip   pip install cx Oracle  Or install manually  Download the cx Oracle source zip that corresponds with your Python and Oracle version  Then expand the archive  and run from the extracted directory   python setup py build  python setup py install

User · Answer

I think it may be the sudo has no access to get ORACLE HOME You can do like this      sudo visudo   modify the text add      Defaults env keep     ORACLE HOME     then     sudo python setup py build install

User · Answer

If you are trying to install in MAC   just  unzip the Oracle client which you downloaded and place it into the folder where you written python scripts  it will start working    There is too much problem of setting up environmental variables   It worked for me   Hope this helps   Thanks

User · Answer

I recommend that you grab the rpm files and install them with alien  That way  you can later on run apt-get purge no-longer-needed   In my case  the only env variable I needed is LD LIBRARY PATH  so I did   echo export LD LIBRARY PATH  usr lib oracle 11 2 client lib  gt  gt     bashrc source    bashrc   I suppose in your case that path variable will be  usr lib oracle xe app oracle product 10 2 0 client lib

User · Answer

The following worked for me  both on mac and Linux  This one command should download needed additional files  without need need to set environment variables   python -m pip install cx Oracle --pre   Note  the --pre option is for development and pre-release of the Oracle driver  As of this posting  it was grabbing cx Oracle-6 0rc1 tar gz  which was needed   I m using python 3 6

User · Answer

This worked for me  python -m pip install cx Oracle --upgrade   For details refer to the oracle quick start guide  https   cx-oracle readthedocs io en latest installation html quick-start-cx-oracle-installation

User · Answer

Try to reinstall it with the following code    pip install --proxy http   username windowspwd 10 200 72 2 8080 --upgrade --force-reinstall cx Oracle

User · Answer

Thanks Burhan Khalid  Your advice to make a a soft link make my installation finally work   To recap    You need both the basic version and the SDK version of instant client You need to set both LD LIBRARY PATH and ORACLE HOME You need to create a soft link  ln -s libclntsh so 12 1 libclntsh so in my    case    None of this is documented anywhere  which is quite unbelievable and quite frustrating  I spent over 3 hours yesterday with failed builds because I didn t know to create a soft link

User · Answer

Thx Burhan Khalid  I overlooked your  You need to be root  quote  but found the way when you are not the root here   At point 7 you need to use    sudo env ORACLE HOME  ORACLE HOME python setup py install    Or   sudo env ORACLE HOME  path to instantclient python setup py install

[python] install cx_oracle for python

Examples related to python

Examples related to oracle