Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit
Brought to you by:
atuining
From: Mark H. <mh...@pi...> - 2011-04-16 00:52:46
|
On 4/15/11 4:02 PM, Chris Gould wrote: > Hi - > I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which is running fine. I've also downloaded the source code for cx_Oracle and tried to get it working. > I've followed the instructions (python setup.py build , python setup.py install) and this seems to work OK. But when I come to try importing cx_Oracle I'm repeatedly getting the following error : > > > >>> import cx_Oracle > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so, 2): Symbol not found: _OCIAttrGet > Referenced from: /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so > Expected in: flat namespace > in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so > > I have set up the symlink in /usr/local/instantclient_10_2_64 > > lrwxr-xr-x 1 root staff 20 15 Apr 23:55 libclntsh.dylib -> libclntsh.dylib.10.1 > -rwxr-xr-x@ 1 chris staff 25582048 31 Mar 2009 libclntsh.dylib.10.1 > > > I've got the following environment variables set (which some googling seems to imply might have been responsible for the problem) > > DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64 > LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64: > ORACLE_HOME=/usr/local/instantclient_10_2_64 > > > The instantclient libraries came from Oracle's website : I've got the basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't know if that's strictly necessary). > > Anyone got any ideas what's going wrong? In my experience, nothing but grief comes from setting environment variables to get oracle running. Here's what worked for me: http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables HTH! Mark |