Thread: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users
|
From: Chris G. <chr...@to...> - 2011-04-15 23:02:53
|
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. |
|
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 |
|
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
>
|
|
From: Anthony T. <ant...@gm...> - 2011-04-22 20:50:55
|
Hi, The line numbers you provide in your description don't match the ones that I have in my 5.1 installation....but I was able to find out where you were referring to, I believe. And I don't believe that your changes are necessary. You'll note on line 167 this line libDirs = [libPath, oracleHome] so you can see that the library path includes whatever ORACLE_HOME is. I've just checked in changes to further simplify things as earlier in the code in the CheckOracleHome() method the location of the clntsh library is determined. In any case, with the base 5.1 install and the new changes I just checked in I was able to successfully build cx_Oracle on my Mac Mini. So I'm not sure why you needed to make the changes you did. Can you try the vanilla one again and show me your error? Thanks. Anthony On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould <chr...@to...> wrote: > 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 > > > ------------------------------------------------------------------------------ > Fulfilling the Lean Software Promise > Lean software platforms are now widely adopted and the benefits have been > demonstrated beyond question. Learn why your peers are replacing JEE > containers with lightweight application servers - and what you can gain > from the move. http://p.sf.net/sfu/vmware-sfemails > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Chris G. <chr...@to...> - 2011-04-22 20:57:58
|
Hi Anthony - all the errors I got when using the original file are in the first email I posted. The build / install appears to work, but when trying to then import cx_Oracle I get the errors as described. Is your installation using InstantClient? Chris. On 22 April 2011 21:50, Anthony Tuininga <ant...@gm...> wrote: > Hi, > > The line numbers you provide in your description don't match the ones > that I have in my 5.1 installation....but I was able to find out where > you were referring to, I believe. And I don't believe that your > changes are necessary. You'll note on line 167 this line > > libDirs = [libPath, oracleHome] > > so you can see that the library path includes whatever ORACLE_HOME is. > I've just checked in changes to further simplify things as earlier in > the code in the CheckOracleHome() method the location of the clntsh > library is determined. > > In any case, with the base 5.1 install and the new changes I just > checked in I was able to successfully build cx_Oracle on my Mac Mini. > So I'm not sure why you needed to make the changes you did. Can you > try the vanilla one again and show me your error? Thanks. > > Anthony > > On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould <chr...@to...> > wrote: > > 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 > > > > > > > ------------------------------------------------------------------------------ > > Fulfilling the Lean Software Promise > > Lean software platforms are now widely adopted and the benefits have been > > demonstrated beyond question. Learn why your peers are replacing JEE > > containers with lightweight application servers - and what you can gain > > from the move. http://p.sf.net/sfu/vmware-sfemails > > _______________________________________________ > > cx-oracle-users mailing list > > cx-...@li... > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > > > |
|
From: Christopher J. <chr...@or...> - 2011-04-25 19:40:08
|
Ideally installation of cx_Oracle would not overload the use of the ORACLE_HOME variable. We try and promote that Instant Client doesn't need ORACLE_HOME set to run :) Chris On 04/22/2011 01:50 PM, Anthony Tuininga wrote: > Hi, > > The line numbers you provide in your description don't match the ones > that I have in my 5.1 installation....but I was able to find out where > you were referring to, I believe. And I don't believe that your > changes are necessary. You'll note on line 167 this line > > libDirs = [libPath, oracleHome] > > so you can see that the library path includes whatever ORACLE_HOME is. > I've just checked in changes to further simplify things as earlier in > the code in the CheckOracleHome() method the location of the clntsh > library is determined. > > In any case, with the base 5.1 install and the new changes I just > checked in I was able to successfully build cx_Oracle on my Mac Mini. > So I'm not sure why you needed to make the changes you did. Can you > try the vanilla one again and show me your error? Thanks. > > Anthony > > On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould<chr...@to...> wrote: >> 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 >> >> >> ------------------------------------------------------------------------------ >> Fulfilling the Lean Software Promise >> Lean software platforms are now widely adopted and the benefits have been >> demonstrated beyond question. Learn why your peers are replacing JEE >> containers with lightweight application servers - and what you can gain >> from the move. http://p.sf.net/sfu/vmware-sfemails >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > ------------------------------------------------------------------------------ > Fulfilling the Lean Software Promise > Lean software platforms are now widely adopted and the benefits have been > demonstrated beyond question. Learn why your peers are replacing JEE > containers with lightweight application servers - and what you can gain > from the move. http://p.sf.net/sfu/vmware-sfemails > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Email: chr...@or... Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ |
|
From: Chris G. <chr...@to...> - 2011-04-25 19:50:26
|
Hi Chris - I don't think cx_Oracle needs ORACLE_HOME set to run (just checked it and it runs fine without it set - only runtime requirement is that instantclient directory is in DYLD_LIBRARY_PATH). It only requires ORACLE_HOME to be set when building cx_Oracle from source code. Chris. On 25 April 2011 20:39, Christopher Jones <chr...@or...>wrote: > > Ideally installation of cx_Oracle would not overload the use of the > ORACLE_HOME variable. We try and promote that Instant Client doesn't > need ORACLE_HOME set to run :) > > Chris > > On 04/22/2011 01:50 PM, Anthony Tuininga wrote: > > Hi, > > > > The line numbers you provide in your description don't match the ones > > that I have in my 5.1 installation....but I was able to find out where > > you were referring to, I believe. And I don't believe that your > > changes are necessary. You'll note on line 167 this line > > > > libDirs = [libPath, oracleHome] > > > > so you can see that the library path includes whatever ORACLE_HOME is. > > I've just checked in changes to further simplify things as earlier in > > the code in the CheckOracleHome() method the location of the clntsh > > library is determined. > > > > In any case, with the base 5.1 install and the new changes I just > > checked in I was able to successfully build cx_Oracle on my Mac Mini. > > So I'm not sure why you needed to make the changes you did. Can you > > try the vanilla one again and show me your error? Thanks. > > > > Anthony > > > > On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould<chr...@to...> > wrote: > >> 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 > >> > >> > >> > ------------------------------------------------------------------------------ > >> Fulfilling the Lean Software Promise > >> Lean software platforms are now widely adopted and the benefits have > been > >> demonstrated beyond question. Learn why your peers are replacing JEE > >> containers with lightweight application servers - and what you can gain > >> from the move. http://p.sf.net/sfu/vmware-sfemails > >> _______________________________________________ > >> cx-oracle-users mailing list > >> cx-...@li... > >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > >> > >> > > > > > ------------------------------------------------------------------------------ > > Fulfilling the Lean Software Promise > > Lean software platforms are now widely adopted and the benefits have been > > demonstrated beyond question. Learn why your peers are replacing JEE > > containers with lightweight application servers - and what you can gain > > from the move. http://p.sf.net/sfu/vmware-sfemails > > _______________________________________________ > > cx-oracle-users mailing list > > cx-...@li... > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- > Email: chr...@or... > Tel: +1 650 506 8630 > Blog: http://blogs.oracle.com/opal/ > > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Mark H. <mh...@pi...> - 2011-04-25 21:23:15
|
On 4/25/11 12:49 PM, Chris Gould wrote: > Hi Chris - > I don't think cx_Oracle needs ORACLE_HOME set to run (just checked it and it runs fine without it set - only runtime requirement is that instantclient directory is in DYLD_LIBRARY_PATH). It only requires ORACLE_HOME to be set when building cx_Oracle from source code. That doesn't have to be the case. If you install the instantclient libs and headers into /lib and /include you shouldn't need to set any environment variables, including DYLD_LIBRARY_PATH. My recipes for setting things up this way are here... if there's anything that doesn't work, let me know and I'll update. http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X