- Download Instant Client:
- instantclient-basic-macos.x64-11.2.0.4.0.zip
- instantclient-sdk-macos.x64-11.2.0.4.0.zip
- instantclient-sqlplus-macos.x64-11.2.0.4.0.zip
-
Unzip and move to /opt
-
Create symlink
$ cd /opt/instantclient_11_2/ $ ln -s libclntsh.dylib.11.1 libclntsh.dylib -
[ This step might not be needed ]
Copy files:
sudo cp /opt/instantclient_11_2/sdk/include/*.h /usr/include/ sudo cp /opt/instantclient_11_2/*.dylib /usr/lib sudo cp /opt/instantclient_11_2/sqlplus /usr/bin -
Run pip install. If it needs root permission, su to root first. Make sure you do this rather than sudo because you need to set the environment variable in the correct shell
export ORACLE_HOME=/opt/instantclient_11_2 pip install cx_Oracle -
Test:
Python 2.7.6 (default, Sep 9 2014, 15:04:36) [GCC 4.2.1 Compatible Apple LLVM 6.0 (clang-600.0.39)] on darwin Type "help", "copyright", "credits" or "license" for more information. >>> import cx_Oracle >>> conn_str = u'USER/[email protected]:1521/orcl' >>> conn = cx_Oracle.connect(conn_str) >>> c = conn.cursor() >>> c.execute(u'select sysdate from dual') <cx_Oracle.Cursor on <cx_Oracle.Connection to USER/[email protected]:1521/orcl>> >>> for row in c: ... print row ... (datetime.datetime(2015, 2, 19, 15, 56, 5),) >>>
If you get this:
Python 2.7.6 (default, Sep 9 2014, 15:04:36)
[GCC 4.2.1 Compatible Apple LLVM 6.0 (clang-600.0.39)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: dlopen(/Library/Python/2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
Referenced from: /Library/Python/2.7/site-packages/cx_Oracle.so
Reason: image not found
Then make sure you've set DYLD_LIBRARY_PATH correctly:
export DYLD_LIBRARY_PATH=/opt/instantclient_11_2/