python - 无法在 OS X 中导入 cx_oracle

Question

我已经使用pip成功安装了cx_oracle，但是出现错误

ImportError: dlopen(/usr/local/lib/python2.7/site-packages/cx_Oracle.so, 2): Library not loaded: libclntsh.dylib.11.1
Referenced from: /usr/local/lib/python2.7/site-packages/cx_Oracle.so
Reason: unsafe use of relative rpath libclntsh.dylib.11.1 in /usr/local/lib/python2.7/site-packages/cx_Oracle.so with restricted binary

当我使用 ipython 控制台导入 cx_Oracle 时发生。更重要的是另一个错误

ImportError: dlopen(/usr/local/lib/python2.7/site-packages/cx_Oracle.so, 2): Library not loaded: libclntsh.dylib.11.1
Referenced from: /usr/local/lib/python2.7/site-packages/cx_Oracle.so
Reason: image not found

当我使用默认的 python 控制台时发生。
它在pycharm ide中也不起作用，我花了很多时间在这方面，有人知道如何解决它吗？谢谢

Answer 1

您是否安装了 Oracle Instant Client 和 SDK？

如果是这样，您必须根据您放置客户端的位置适当导出库路径。例如:

PATH=$PATH:/Library/Oracle/instantclient_11_2
DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/Library/Oracle/instantclient_11_2
CLASSPATH=$CLASSPATH:$ORACLE_HOME
TNS_ADMIN=/Library/Oracle/instantclient_11_2/network/admin

export TNS_ADMIN
export PATH
export DYLD_LIBRARY_PATH
export CLASSPATH