centos7安装cx_Oracl

来源:互联网 发布:lol西门代练淘宝店 编辑:程序博客网 时间:2024/06/07 09:10

1. 首先安装

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm

oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm


下载并上传这3个东西到服务器。

命令: rpm -ivh oracle* 


2.修改.bashrc文件,建立环境变量

echo '# Convoluted undocumented Oracle bullshit.' >> $HOME/.bashrc
echo 'export ORACLE_VERSION="12.2"' >> $HOME/.bashrc
echo 'export ORACLE_HOME="/usr/lib/oracle/$ORACLE_VERSION/client64"' >> $HOME/.bashrc
echo 'export PATH=$PATH:"$ORACLE_HOME/bin"' >> $HOME/.bashrc
echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:"$ORACLE_HOME/lib"' >> $HOME/.bashrc
echo 'export TNS_ADMIN="$ORACLE_HOME/network/admin"' >> $HOME/.bashrc
--解决sqlplus乱码
--echo 'export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"' >> $HOME/.bashrc
echo 'export NLS_LANG="AMERICAN_AMERICA.UTF8"' >> $HOME/.bashrc 

3.--更新环境变量
. $HOME/.bashrc 

4. 下载cx_Oracle 并安装
wget https://pypi.python.org/packages/14/05/4d492fb049eeee24ff8b5fdf23c6240b81ef168d4039dfbf6629e022ba6b/cx_Oracle-5.3.tar.gz#md5=4351b3ef99a1a247f772ae5d97fdc060
tar -zxvf  cx_Oracle-5.3.tar.gz
cd cx_Oracle-5.3
python setup.py install