As I understand it, there was some change related to SIP that makes installing this difficult.
These pages have the background and advice to install. http://sourceforge.net/p/cx-oracle/mailman/message/34534872/, http://stefanoapostolico.com/2015/10/08/install_cx_oracle_with_sip_enabled.html
Putting all this together, here was my best shot at installing it to my virtualenv but alas, still no good.
The error I'm getting is:
Traceback (most recent call last):
File "<string>", line 1, in <module>
ImportError: dlopen(/Users/me/sx_direct_env/lib/python2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /b/227/rdbms/lib/libclntsh.dylib.10.1
Referenced from: /Users/me/sx_direct_env/lib/python2.7/site-packages/cx_Oracle.so
Reason: image not found
Here are all of my install steps:
$ cd /Users/me/sx_direct_env/lib/python2.7
$ mkdir oracle
$ cd oracle
$ export ORACLE_HOME=$PWD
$ export DYLD_LIBRARY_PATH=$ORACLE_HOME
$ export LD_LIBRARY_PATH=$ORACLE_HOME
$ export PATH=$PATH:$ORACLE_HOME
$ unzip ~/Downloads/instantclient-basic-macos.x64-11.2.0.4.0.zip
$ unzip ~/Downloads/instantclient-sdk-macos.x64-11.2.0.4.0.zip
$ mv instantclient_11_2/* .
$ rmdir instantclient_11_2
$ curl -O https://raw.githubusercontent.com/kubo/fix_oralib_osx/master/fix_oralib.rb
$ ruby -a fix_oralib.rb
adrci:
add rpath: @loader_path
change install name
from: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
change install name
from: /ade/dosulliv_ldapmac/oracle/ldap/lib/libnnz11.dylib
to: @rpath/libnnz11.dylib
genezi:
add rpath: @loader_path
change install name
from: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
libclntsh.dylib.11.1:
add rpath: @loader_path
change identification name
from: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
change install name
from: /ade/dosulliv_ldapmac/oracle/ldap/lib/libnnz11.dylib
to: @rpath/libnnz11.dylib
libnnz11.dylib:
change identification name
from: /ade/dosulliv_ldapmac/oracle/ldap/lib/libnnz11.dylib
to: @rpath/libnnz11.dylib
libocci.dylib.11.1:
change identification name
from: /ade/b/3071542110/oracle/rdbms/lib/libocci.dylib.11.1
to: @rpath/libocci.dylib.11.1
libociei.dylib:
add rpath: @loader_path
change install name
from: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
libocijdbc11.dylib:
add rpath: @loader_path
change install name
from: /ade/b/2475221476/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
change install name
from: /ade/b/2475221476/oracle/ldap/lib/libnnz11.dylib
to: @rpath/libnnz11.dylib
uidrvci:
add rpath: @loader_path
change install name
from: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
to: @rpath/libclntsh.dylib.11.1
change install name
from: /ade/dosulliv_ldapmac/oracle/ldap/lib/libnnz11.dylib
to: @rpath/libnnz11.dylib
$ pip install cx_oracle
Collecting cx-oracle
Installing collected packages: cx-oracle
Successfully installed cx-oracle-5.2
$ python -c "import cx_Oracle"
Traceback (most recent call last):
File "<string>", line 1, in <module>
ImportError: dlopen(/Users/me/sx_direct_env/lib/python2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /b/227/rdbms/lib/libclntsh.dylib.10.1
Referenced from: /Users/me/sx_direct_env/lib/python2.7/site-packages/cx_Oracle.so
Reason: image not found
I think I fixed it. Basically everything in my steps posted above were correct.
But I ended up using this for the pip install to make sure it pulls down a new copy and rebuilds (and maybe gets a later version??)
$ pip install --no-cache-dir --allow-external --allow-unverified cx_oracle
I was then able to import cx_oracle without issues but I was getting an error "'ORA-21561: OID generation failed'" when connecting to the external server.
Then I followed the instructions here and added a line with my host name to the /etc/hosts file and it all works now.
e.g., added a line like this at the end of /etc/hosts
127.0.0.1 localhost my-host-name