linux cx_oracle,linux 安装cx_Oracle

一、安装必要的库

yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel gcc python-devel

二、安装setuptools

下载setuptools安装包，并解压

python setup.py install

三、安装pip

下载pip安装包，并解压

python setup.py install

四、安装cx_Oracle

直接用pip安装

pip install cx_Oracle

五、使用的时候，得装一个oracle客户端

六、配置环境变量：

export ORACLE_HOME=/root/oracle

export LD_LIBRARY_PATH=/root/oracle

PATH=$PATH

export PATH

七、测试代码：

import cx_Oracle

dsn = cx_Oracle.makedsn("10.0.12.1", "1521", "orcl")

conn = cx_Oracle.connect("ftcore", "ftcore", dsn)

c = conn.cursor()

query_sql = "select count(1) from ftc_match"x = c.execute(query_sql)

row = x.fetchall()

oracle_size = int(row[0][0])

oracle_size