python3连接oracle

安装oracle驱动

下载地址：Instant Client for Linux x86-64 (64-bit)

yum install oracle-instantclient-basic-21.10.0.0.0-1.x86_64.rpm -y

安装python3及pip

yum install python3 python3-pip -y 

安装cx_Oracle

pip install cx_Oracle

测试

#!/usr/bin/python3

def test():
    import cx_Oracle
    #import os
    #os.environ["ORACLE_HOME"] = r'/root/oracle/instantclient_12_2'
    user = 'test'
    password = 'test1234'
    host = '10.0.0.101:1521'
    service_name = 'TESTDB'
    conn_str = f"{user}/{password}@{host}/{service_name}"
    connect = cx_Oracle.connect(conn_str)
    cursor = connect.cursor()
    cursor.execute('select * from TEST.MES_ZSX_TEST where ROWNUM <=10')
    print(cursor.fetchall())

test()