cx_Oracle python模組安裝

標籤：

1. 需要從oracle網站下載一下兩個包

instantclient-basic-linux.x64-11.2.0.4.0.zip

instantclient-sdk-linux.x64-11.2.0.4.0.zip

2. 下載後解壓到某目錄下，如：/oracle

3. 根據解壓後的 BUILD.txt 步驟進行配置：

　　3.1 

 cat .bash_profile # .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsORACLE_HOME=/oracle/instantclient_11_2PATH=$PATH:$HOME/bin:$ORACLE_HOMELD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME:$ORACLE_HOME/sdkexport LD_LIBRARY_PATHexport PATH

配置bash_profile

　　3.2

　　　　python setup.py build
　　　　python setup.py install

 

3.3如果出現如下錯誤，則需要安裝 python-devel-2.6.6-64.el6.x86_64

cx_Oracle.c:6:20: error: Python.h: No such file or directorycx_Oracle.c:7:22: error: datetime.h: No such file or directorycx_Oracle.c:8:26: error: structmember.h: No such file or directoryIn file included from cx_Oracle.c:142:Buffer.c:13: error: expected specifier-qualifier-list before ‘PyObject’Buffer.c: In function ‘cxBuffer_Init’:Buffer.c:28: error: ‘udt_Buffer’ has no member named ‘obj’Buffer.c: In function ‘cxBuffer_Copy’:Buffer.c:44: warning: implicit declaration of function ‘Py_XINCREF’Buffer.c:44: error: ‘udt_Buffer’ has no member named ‘obj’Buffer.c:45: error: ‘udt_Buffer’ has no member named ‘obj’Buffer.c:45: error: ‘udt_Buffer’ has no member named ‘obj’

View Code

 

cx_Oracle python模組安裝