centos之Python3.7安装cx_Oracle

朱雀 2023-06-30 08:56 8阅读 0赞

1、环境  
![centos安装cx\_Oracle][centos_cx_Oracle]  
2、安装oracle客户端（我下载的rpm格式）  
地址[oracle客户端][oracle]  
3、安装  
上传到服务器  
![centos安装cx\_Oracle][centos_cx_Oracle 1]  
（1）yum install -y libaio  
（2）rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86\_64.rpm  
（3）安装python客户端cx\_Oracle  
pip3 install cx\_Oracle  
![centos安装cx\_Oracle][centos_cx_Oracle 2]  
(4)、配置环境变量  
vim /etc/profile  
添加  
export ORACLE\_HOME=/usr/lib/oracle/12.2/client64/lib  
export LD\_LIBRARY\_PATH=$LD\_LIBRARY\_PATH:$ORACLE\_HOME  
![centos安装cx\_Oracle][centos_cx_Oracle 3]  
source /etc/profile  
4、验证  
![centos安装cx\_Oracle][centos_cx_Oracle 4]

ps：编码问题，需要配置环境变量

os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'

原文出处：[https://blog.51cto.com/leizhu/2113529][https_blog.51cto.com_leizhu_2113529]

[centos_cx_Oracle]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9zMS41MWN0by5jb20vaW1hZ2VzL2Jsb2cvMjAxODA1LzA3LzVjMWNiZjAzMDM4NDU0Y2Y3OGYwNjVjNmVhNjA4ZjhkLnBuZw?x-oss-process=image/format,png
[oracle]: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
[centos_cx_Oracle 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9zMS41MWN0by5jb20vaW1hZ2VzL2Jsb2cvMjAxODA1LzA3L2E2ZjBmODFlODg0NTQ1NjZiZGYzNWYwOGZhOGMyZDYwLnBuZw?x-oss-process=image/format,png
[centos_cx_Oracle 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9zMS41MWN0by5jb20vaW1hZ2VzL2Jsb2cvMjAxODA1LzA3Lzc2ZDViN2YyMDI2MDkzODdjMDAwMTNhNWE3NmQyNDJiLnBuZw?x-oss-process=image/format,png
[centos_cx_Oracle 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9zMS41MWN0by5jb20vaW1hZ2VzL2Jsb2cvMjAxODA1LzA3LzYwZmZlNzFmOThkY2M1MGI5ZThmODM2MTU2ZWNlNTgzLnBuZw?x-oss-process=image/format,png
[centos_cx_Oracle 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9zMS41MWN0by5jb20vaW1hZ2VzL2Jsb2cvMjAxODA1LzA3LzhkMDJlNGQ1MDQ2MTEwZjI2ZDBjMzllNTdmNDdkMDExLnBuZw?x-oss-process=image/format,png
[https_blog.51cto.com_leizhu_2113529]: https://blog.51cto.com/leizhu/2113529