Python连接Oracle

Python连接Oracle

1、下载cx_Oracle包

pip install cx_Oracle

2、配置instant-client（否则会报错：cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library）

instant-client下载地址：https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

下载完成后，将.dll后缀的文件复制到python的安装目录中

Python连接Oracle配置

if __name__ == '__main__':
    
    print('process starting...')

    username = "username"
    password = "password"
    host = "10.10.20.20"
    port = "1523"
    sid = "sid"
    dsn = cx_Oracle.makedsn(host, port, sid)
    con = cx_Oracle.connect(username, password, dsn)
    cursor = con.cursor()
    print('连接数据库成功！')
    
    sql = '''select * from user_info where user_id=123456'''
    result1 = cursor.execute(sql)
    result = pd.DataFrame(result1)
    print(result)