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

Required lib library: yum install gcc libffi-devel python-devel openssl-devel

Source code installation:

Download address: https://pypi.python.org/pypi/cx_Oracle/5.2.1

Installation: 1.tar zxvf cx_Oracle-5.2.1.tar.gz

2. Cd cx_Oracle-5.2.1

3. Python3 setup.py install

After the installation is completed, the following error occurs in import cx_Oracle:

ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Solution:

Log in to 1 as the root user, find the oracle lib location: / u01/app/oracle/product/11.2.0/client_1/lib 2, create a new oracle.conf under the directory / etc/ld.so.conf.d, write the above location information, and save: / u01/app/oracle/product/11.2.0/client_1/lib 3. The problem with running the ldconfig command python2: after connecting to oracle As a result, the solution to the garbled code problem: import osos.environ ['NLS_LANG'] =' SIMPLIFIED CHINESE_CHINA.UTF8'cx_Oracle module needs to use oracle's lib library to connect to the database. If it cannot be found, it will report an error: cx_Oracle.DatabaseError: DPI-1005: unable to acquire Oracle environment handle solution: modify / etc/profile file Add: after the export ORACLE_BASE=/oracle/appexport ORACLE_HOME=$ORACLE_BASE/product/11204export JAVA_HOME=/usr/java/jdk1.8.0_131export PATH=$JAVA_HOME/bin:$ORACLE_BASE/product/11204/bin:$PATH modification is completed, execute source / etc/profile to make the modification take effect.

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.