1、安装cx_Oracle
2、下载oracle的instantclient解压,拷贝oci.dll,oraocci11.dll,oraociei11.dll 至python安装目录下的 Lib\site-packages
3、设置环境变量(Linux)
vim /root/.bash_profile
ORACLE_HOME=/opt/instantclient_11_2
PATH=$PATH:$ORACLE_HOME/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
source ~/.bash_profile
vim /etc/ld.so.conf 加入
/opt/instantclient_11_2
执行ldconfig生效
ldconfig