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

布满荆棘的人生 2022-09-16 11:24 331阅读 0赞

1. 先去Oracle官网下载 oracle client

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

![d20aefe07d61feda44dcc847f2e0e80a.png][]

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

![62919a4ae0e333a44242ebbc65b64537.png][]

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
    
    conn = cx_Oracle.connect('用户名/密码@ip:端口/服务名')
    curs = conn.cursor()
    sql = 'select * from product_component_version'
    curs.execute(sql)
    
    for result in curs:
        print(result)
    
    curs.close()
    conn.close()

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 </td> 
 <td> <code>import</code>&nbsp;<code>cx_Oracle</code> <code># ln -s ~/instantclient_19_8/libclntsh.dylib ~/lib/</code> <code>def</code>&nbsp;<code>test():</code> <code>&nbsp;&nbsp;&nbsp;&nbsp;</code><code>conn&nbsp;</code><code>=</code>&nbsp;<code>cx_Oracle.connect(</code><code>"qtpay/qtpay@192.168.1.139:1521/orcl"</code><code>)</code> <code>&nbsp;&nbsp;&nbsp;&nbsp;</code><code>cur&nbsp;</code><code>=</code>&nbsp;<code>conn.cursor()</code> <code>&nbsp;&nbsp;&nbsp;&nbsp;</code><code>r&nbsp;</code><code>=</code>&nbsp;<code>cur.execute(</code><code>"select sysdate from dual"</code><code>)</code> <code>&nbsp;&nbsp;&nbsp;&nbsp;</code><code>print</code><code>(r.fetchall())</code> <code>if</code>&nbsp;<code>__name__&nbsp;</code><code>=</code><code>=</code>&nbsp;<code>'__main__'</code><code>:</code> <code>&nbsp;&nbsp;&nbsp;&nbsp;</code><code>test()</code> </td> 
 </tr> 
 </tbody> 
</table>

![7ec6796bd411f270c3f43c4339e5252f.png][]

[d20aefe07d61feda44dcc847f2e0e80a.png]: /images/20220828/5ba06f4c09ca4a1e850d369eeaec3d4a.png
[62919a4ae0e333a44242ebbc65b64537.png]: /images/20220828/3a82482490a94779acf6fc00b283a792.png
[7ec6796bd411f270c3f43c4339e5252f.png]: /images/20220828/9b7d3670bd3349b282c77d486f5cb1cd.png