centos安装oracle客户端，供python调用cx_oracle遇到的问题

最新推荐文章于 2024-10-12 07:46:51 发布

原创最新推荐文章于 2024-10-12 07:46:51 发布 · 1.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #python #cx_oracle #centos

本文解决在使用Python的cx_Oracle模块连接Oracle数据库时遇到的DatabaseError:DPI-1047错误，详细介绍了如何安装libaio，以及如何正确配置libclntsh.so、libnnz11.so等Oracle客户端库文件。

Traceback (most recent call last):
File "test.py", line 2, in <module>
conn = cx_Oracle.connect("xxxx/xxxx@xxx.1.32.xxx/orcl")
cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help

Traceback (most recent call last):
File "test.py", line 2, in <module>
conn = cx_Oracle.connect("xxxx/xxxx@xxx.1.32.xxx/orcl")
cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "libnnz11.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help

Traceback (most recent call last):
File "test.py", line 2, in <module>
conn = cx_Oracle.connect("xxxx/xxxx@xxx.1.32.xxx/orcl")
cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-01804
Segmentation fault (core dumped)

需要做几件事

1、安装libaio，yum install libaio

2、libclntsh.so libclntsh.so.11.1 libnnz11.so libocci.so libocci.so.11.1 libociei.so libocijdbc11.so

其中libclntsh.so -> libclntsh.so.11.1，libocci.so -> libocci.so.11.1

3、执行ldconfig