Shulou(Shulou.com)06/01 Report--

Notes for installing cx_Oracle:

First of all, when you install the configuration, you must grasp one point, that is, the version is consistent! Including: system version, python version, oracle client version, cx_Oracle version, and then easy to install and configure!

If you have already installed Python, check how many bits are in the version of Python you installed, as follows:

> import platform

> > platform.architecture ()

View the number of version digits of the Oracle database:

SQL > select * from vandalism Banner

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit

ProductionPL/SQL Release 11.2.0.4.0-ProductionCORE

11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0-Production

NLSRTL Version 11.2.0.4.0-Production

Of course, your 64-bit operating system can also install a 32-bit development environment. On the contrary, no! Remember!

The version of oracle client, the version of cx_Oracle, which corresponds to the version and number of digits of Python, for example:

Python version: Python 3.5.1 64-bit

Oracle client version: instantclient-basic-linux.x64-11.2.0.4.0.zip

Choose 64-bit when choosing cx_Oracle-5.3!

Here are three more points to note:

Version digits correspond to 64 bits

Cx_Oracle and python version correspond to 3.5.1

Cx_Oracle and instantclient versions correspond to 11g

The process of installing cx_Oracle on Linux:

One: install python3

1. Prepare the compilation environment

Yum groupinstall 'Development Tools'

Yum install zlib-devel bzip2-devel openssl-devel ncurese-devel

Yum-y install gcc python-devel

two。 Download the python3.5 package

Wget https://www.python.org/ftp/python/3.5.1/Python-3.5.1.tar.xz

3. Decompress, compile

Tar Jxvf Python-3.5.1.tar.xz

Cd Python-3.5.1

. / configure-- prefix=/usr/local/python3

Make & & make install

Note the-prefix option here. Install python3 in the / usr / local / python3 directory, and the previously downloaded zip and installation packages can be deleted directly.

4. Replace the default python and pip versions of the system

Mv / usr/bin/python / usr/bin/python

2.6 establish soft links to the new python3 and PIP 3

Ln-s / usr/local/python3/bin/python3.5 / usr/bin/python

Ln-s / usr/local/python3/bin/pip3 / usr/bin/pip

Second: install the oracle client tool instantclient-basic-linux.x64-11.2.0.4.0.zip

Download address: https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download the zip package directly and decompress it!

1. Set up the installation directory of oracle

[root@dev-bibaobiao-04] # mkdir-p / data/oracle

2. Put the installation package instantclient-basic-linux.x64-11.2.0.4.0.zip under / data/oracle/, and then decompress it

[root@dev-bibaobiao-04 oracle] # unzip instantclient-basic-linux.x64-11.2.0.4.0.zip

Generate directory: / data/oracle/instantclient_11_23

3. Configure environment variables: / ect/profile or / root/.bash_profile file

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Export ORACLE_IC_HOME=/data/oracle/instantclient_11_2

Export ORACLE_HOME=$ORACLE_IC_HOME

Export TNS_ADMIN=$ORACLE_IC_HOME

Export PATH=$PATH:$HOME/bin:$ORACLE_IC_HOME

Export LD_LIBRARY_PATH=$ORACLE_IC_HOME:/usr/lib

Three: install the cx_Oracle plug-in

[root@tool202 bin] # pip install cx_Oracle

Or to prevent errors, you can choose to download the corresponding version yourself:

Https://pypi.org/project/cx_Oracle/5.3/#files

[root@tool202 python] # tar-zxvf cx_Oracle-5.3.tar.gz

[root@tool202 cx_Oracle-5.3] # python setup.py install

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.