[DB-SIG] cx_Oracle Oracle 10g on Linux

[Anthony Tuininga]

On Wed, 2004-04-28 at 10:26, Andy Todd wrote:
> Hi all,
> 
> I've just installed Oracle 10g on my Debian box and am now trying to 
> talk to it from Python.
> 
> I've downloaded and installed cx_Oracle 4.0.1 but when I try and import 
> the module I get an error;
> 
> """
> Python 2.3.3 (#2, Feb 24 2004, 09:29:20)
> [GCC 3.3.3 (Debian)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>  >>> import cx_Oracle
> Traceback (most recent call last):
>    File "<stdin>", line 1, in ?
> ImportError: libclntsh.so.10.1: cannot open shared object file: No such 
> file or directory
>  >>>
> """
> 
> For the record, Oracle 10g does have a libclntsh.so (in $ORACLE_HOME/lib)
> 
> I note that Anthony says that the code works on Linux 
> (http://aspn.activestate.com/ASPN/Mail/Message/db-sig/2011613) so I'm 
> presuming I am missing some configuration. Does anyone have any suggestions?

Sure. Did you try building cx_Oracle from source? I did not provide
binaries for Oracle 10g yet but you should be able to build from source
without any trouble. If you run into difficulties, send me an e-mail and
I'll see if I can help you get things going. Now that Oracle has
released Oracle 10g for Windows as well, the next release of cx_Oracle
will contain binaries for 10g -- that may be a while yet, though. :-)

> Regards,
> Andy
-- 
Anthony Tuininga
anthony at computronix.com
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com