Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit
|
From: Chris G. <chr...@to...> - 2011-04-21 21:25:10
|
I've fixed the problem with cx_Oracle (as I described). I vaguely remember
having a similar problem when I installed cx_Oracle 5.0.3 with an earlier
version of python (2.6). The solution was the same this time.
Because I'm using Instantclient and not a full Oracle installation, I'd set
ORACLE_HOME env var to my instantclient directory.
I also set DYLD_LIBRARY_PATH to point to the InstantClient directory (This
needs to be made a permanent setting in .bash_profile )
I created the extra symlink required in the InstantClient directory :
ln -s libclntsh.dylib.10.1 libclntsh.dylib
I also made 2 small changes to setup.py which came with cx_Oracle5.1.
on line 73, change
elif sys.platform == "darwin":
subDirs = ["lib"]
to
elif sys.platform == "darwin":
subDirs = [""]
and on line 155 change
libPath = os.path.join(oracleHome, "lib")
to
libPath = os.path.join(oracleHome, "")
Then follow the stated instructions for building and installing cx_Oracle
The reason these changes are necessary is that if you've set ORACLE_HOME to
your instantclient directory, the files required are in $ORACLE_HOME not
$ORACLE_HOME/lib as they would be with a full Oracle installation (which is
what setup.py is assuming).
It'd be handy if the distributed setup.py could be modified to cater for the
InstantClient setup, since I guess more people these days will use this than
an old-skool OracleHome installation.
Chris.
On 16 April 2011 01:18, Mark Harrison <mh...@pi...> wrote:
> 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
>
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
