ITPub博客

首页 > 应用开发 > IT综合 > python安装模块cx_Oracle

python安装模块cx_Oracle

原创 IT综合 作者:fjzcau 时间:2016-03-25 11:42:51 0 删除 编辑
#rpm包下载地址 
客户端oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm 下载地址:
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
模块cx_Oracle下载地址:
https://sourceforge.net/projects/cx-oracle/files/

#安装前,import cx_Oracle模块报错
[root@AWS-Dev-172-31-1-140 hadoop]# python
Python 2.7.9 (default, Apr  1 2015, 18:18:03) 
[GCC 4.8.2 20140120 (Red Hat 4.8.2-16)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named cx_Oracle

#安装rpm包,先安装oracle客户端,再安装cx_Oracle模块包 
[root@AWS-Dev-172-31-1-140 hadoop]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm 
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-instantclient11.2-basic-11################################# [100%]
[root@AWS-Dev-172-31-1-140 hadoop]# rpm -ivh cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm 
Preparing...                          ################################# [100%]
Updating / installing...
   1:cx_Oracle-5.1.2-1                ################################# [100%]

#设置环境变量 
[root@AWS-Dev-172-31-1-140 hadoop]# cat >> /etc/profile <<!
# add by fjzcau,2016-03-24,config for oracle client which used by python
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/lib
export LD_LIBRARY_PATH=\$ORACLE_HOME:\$LD_LIBRARY_PATH
export PATH=/usr/lib/oracle/11.2/client/bin:\$PATH
!

#安装后,在python目录下生成文件cx_Oracle.so
[hadoop@AWS-Dev-172-31-1-140 ~]$ ll /usr/lib/python2.7/site-packages
total 360
-rw-r--r-- 1 root root    898 Jul  6  2012 cx_Oracle-5.1.2-py2.7.egg-info
-rwxr-xr-x 1 root root 360085 Jul  7  2012 cx_Oracle.so
-rw-r--r-- 1 root root    119 Apr  2  2015 README

#验证安装是否成功 
[root@AWS-Dev-172-31-1-140 hadoop]# su - hadoop
Last login: Fri Mar 25 10:48:33 CST 2016 from submit01 on pts/2
[hadoop@AWS-Dev-172-31-1-140 ~]$ python
Python 2.7.9 (default, Apr  1 2015, 18:18:03) 
[GCC 4.8.2 20140120 (Red Hat 4.8.2-16)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22661144/viewspace-2063620/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-03

  • 博文量
    208
  • 访问量
    446834