SLTechnology News&Howtos › Database ›

Cx_Oracle installation and configuration of the module python connects to oracle

Shulou Source: shulou.com Published: 2022-06-01 06:45:45 10月03日 Update

Download the appropriate version of cx_Oracle

Install cx_Oracle-5.1.2-11g-py24-1.x86_64.rpm, other versions are similar

Rpm-ivh cx_Oracle-5.1.2-11g-py24-1.x86_64.rpm

Installation is simple, but the following environment variables and soft connections need to be configured

In / etc/profile, add

Export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/

Then create a soft connection

Ln-s / usr/lib/oracle/12.1/client64/lib/libclntshcore.so.12.1 / lib64/libclntshcore.so.12.1

Ln-s / usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1 / lib64/libclntsh.so.12.1

Ln-s / usr/lib/oracle/12.1/client64/lib/libclntsh.so.11.1 / lib64/libclntsh.so.11.1

Ln-s / usr/lib/oracle/12.1/client64/lib/libipc1.so / lib64/libipc1.so

Ln-s / usr/lib/oracle/12.1/client64/lib/libmql1.so / lib64/libmql1.so

Ln-s / usr/lib/oracle/12.1/client64/lib/libnnz12.so / lib64/libnnz12.so

Ln-s / usr/lib/oracle/12.1/client64/lib/libocci.so.12.1 / lib64/libocci.so.12.1

Ln-s / usr/lib/oracle/12.1/client64/lib/libociei.so / lib64/libociei.so

Ln-s / usr/lib/oracle/12.1/client64/lib/libocijdbc12.so / lib64/libocijdbc12.so

Ln-s / usr/lib/oracle/12.1/client64/lib/libons.so / lib64/libons.so

Ln-s / usr/lib/oracle/12.1/client64/lib/liboramysql12.so / lib64/liboramysql12.so

Ln-s / usr/lib/oracle/12.1/client64/lib/ojdbc6.jar / lib64/ojdbc6.jar

Ln-s / usr/lib/oracle/12.1/client64/lib/ojdbc7.jar / lib64/ojdbc7.jar

Ln-s / usr/lib/oracle/12.1/client64/lib/xstreams.jar / lib64/xstreams.jar