Python3.6连接连接Oracle数据库的方法详解数据库的方法详解
主要介绍了Python3.6连接Oracle数据库的方法,较为详细的分析了cx_Oracle模块安装及Python3.6使用
cx_Oracle模块操作Oracle数据库的具体操作步骤与相关注意事项,需要的朋友可以参考下
本文实例讲述了Python3.6连接Oracle数据库的方法。分享给大家供大家参考,具体如下:
下载cx_Oracle模块模块:
https://pypi.python.org/pypi/cx_Oracle/5.2.1#downloads
这里下载的是源码进行安装
[root@oracle oracle]# tar xf cx_Oracle-5.2.1.tar.gz
[root@oracle oracle]# cd cx_Oracle-5.2.1
[root@oracle cx_Oracle-5.2.1]# python setup.py build
Traceback (most recent call last):
File "setup.py", line 170, in <module>
raise DistutilsSetupError("cannot locate an Oracle software " \
distutils.errors.DistutilsSetupError: cannot locate an Oracle software installation
报错解决办法:报错解决办法:在root用户的.bash_profile文件中添加oracle_home的环境变量
export ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1
PATH=${ORACLE_HOME}/bin:$PATH:$HOME/bin
[root@oracle cx_Oracle-5.2.1]# source /root/.bash_profile
[root@oracle cx_Oracle-5.2.1]# echo ${ORACLE_HOME}
/u01/app/product/11.2.0/dbhome_1
然后继续build:
[root@oracle cx_Oracle-5.2.1]# python setup.py build
running build
running build_ext
后面输出信息省略
[root@oracle cx_Oracle-5.2.1]# python setup.py install
running install
running bdist_egg
后面输出信息省略
按照完成之后,进行验证模块:
>>> import cx_Oracle
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory
解决办法:解决办法:在root用户的.bash_profile文件中添加LD_LIBRARY_PATH的环境变量
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
[root@oracle cx_Oracle-5.2.1]# source /root/.bash_profile
[root@oracle cx_Oracle-5.2.1]# python
Python 3.6.1 (default, Jul 13 2017, 14:31:18)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-17)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
#!/usr/bin/python
#coding=utf8
# import module
import cx_Oracle as oracle
# connect oracle database
db = oracle.connect('scott/redhat@192.168.223.138:1521/oracle.test')
评论0