centos6.9安装oracle10,2018-10-09 centos6.9 安装cx_Oracle

1、下载

https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

下载basic rpm，sdk rpm

https://github.com/oracle/python-cx_Oracle/tree/5.3

下载5.3，配合centos6.9的python2.6.6.

2、安装

rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

python setup.py build

python setup.py install

2.7.x和3.x.x非常简单

pip install cx_Oracle

3、 测试

>>> import cx_Oracle

>>> dir(cx_Oracle)

['ATTR_PURITY_DEFAULT', 'ATTR_PURITY_NEW', 。。。

>>> import cx_Oracle

>>> c = cx_Oracle.connect('user/password@192.168.157.144:1521/orcl')

>>> print(c)

>>> cursor = c.cursor()

>>> cursor.execute("select * from dual")

>

>>> print cursor

>

>>> for x in cursor:

...    print x

...

('X',)

>>>