centos 6.5 64位使用python连接oracle 11g

最新推荐文章于 2025-01-10 11:23:17 发布

原创最新推荐文章于 2025-01-10 11:23:17 发布 · 1.9k 阅读

2 ·

CC 4.0 BY-SA版权

oracle常用同时被 2 个专栏收录

39 篇文章

订阅专栏

shell编程

1 篇文章

订阅专栏

本文介绍了如何在CentOS 6.5 64位系统中通过Python连接Oracle 11g数据库。主要内容包括：安装Oracle客户端、配置环境变量、安装cx_Oracle模块以及使用Python进行数据库查询。

centos 6.5 64位使用python连接oracle 11g

1.安装oracle客户端
	yum install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
	yum install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
	
2.配置root用户ORACLE_HOME
    export ORACLE_HOME=/usr/lib/oracle/11.2/client64/lib/
	export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

3.安装cx_Oracle模块
    pip install cx_oracle

4.使用python连接oracle库做查询

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import cx_Oracle as db 
import os 
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' 

def queryOracle(sql):
    username = "dbaro"
    passwd = "xxxxxxxxxx"
    host = "192.168.2.21"
    port = "1521"
    sid = "slave"
    dsn = db.makedsn(host, port, sid)
    con = db.connect(username, passwd, dsn)
    cur = con.cursor()
    cur.execute(sql)
    result  = cur.fetchall()
    cur.close()
    con.close()
    return result


if __name__=="__main__":
    sql = "select sysdate from dual"
    result = queryOracle(sql)
    print result