python安裝模組cx_Oracle

fjzcau發表於2016-03-25
#rpm包下載地址 
客戶端oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm 下載地址:

模組cx_Oracle下載地址:


#安裝前,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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章