python连接Oracle数据库代码

import cx_Oracle as oracle

# db = oracle.connect('用户名/密码@IP:端口号/SERVICE_NAME')
db = oracle.connect('admin/password@IP:1521/DataBase')
cursor = db.cursor()
# execute sql
cursor.execute("'SELECT * FROM dual")
data = cursor.fetchall()

print('Database time:%s' % data)
# close cursor and oracle
cursor.close()
db.close()

若在linux环境下报以下错：DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory"

原因是 oracle客户端是32位的，

解决方法：下载64位的oracle客户端

1、官网下载对应版本的rpm包

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-devel-12.2.0.1.0-1.x86_64.rpm    oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

2、上传到linux解压：

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

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

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

3、解压后，

cd /usr/lib/oracle/12.2/client64

创建目录：mkdir -p ./network/admin

在该目录下创建文件： vi ./network/admin/tnsnames.ora

文件内容如下 ： DB =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))     )  # 需要修改为你自己的host,port,service_name     (CONNECT_DATA =       (SERVICE_NAME = DB)     )   )

4、

vi ~/.bashrc

添加以下：

export  ORACLE_HOME=/usr/lib/oracle/12.2/client64 export ORACLE_BASE=/usr/lib/oracle/12.2 export  TNS_ADMIN=$ORACLE_HOME/network/admin export  LD_LIBRARY_PATH=$ORACLE_HOME/lib export  PATH=$ORACLE_HOME/bin:$PATH export  NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

5、source ~/.bashrc

6、重启python, 连接oracle,成功。

 

python连接hive : https://blog.csdn.net/kerry_55/article/details/105789298

python连接oracle:  https://blog.csdn.net/kerry_55/article/details/93390592