mac 配置Oracle client，Python连接Oracle DPI-1047: Cannot locate a 64-bit Oracle Client library

1. 先去Oracle官网下载 oracle client

https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

 

 

2. 将压缩包解压到 home目录

 

 3.配置环境变量

export ORACLE_HOME=/Users/xxxx/instantclient_19_8

export PATH=$PATH:$ORACLE_HOME

export DYLD_LIBRARY_PATH=$ORACLE_HOME:$DYLD_LIBRARY_PATH

 

source .base_profile

4.home 目录下(xxxx) 创建lib 目录

mkdir ~/lib

5.创建软连

ln -s ~/instantclient_19_8/libclntsh.dylib ~/lib/

ln -s ~/instantclient_19_8/libclntsh.dylib /usr/local/lib/

6.将监听文件tnsnames.ora 拷贝至 /instantclient_19_8/network/admin 目录下

7.运行Python文件

import cx_Oracle


# ln -s ~/instantclient_19_8/libclntsh.dylib ~/lib/
def test():
    conn = cx_Oracle.connect("qtpay/qtpay@192.168.1.139:1521/orcl")
    cur = conn.cursor()
    r = cur.execute("select sysdate from dual")
    print(r.fetchall())


if __name__ == '__main__':
    test()