[cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Chris G. <chr...@to...>]

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?

Happy to receive direct mails if anyone can shed any light on this.

Thanks
Chris.