cx-oracle-users

[cx-oracle-users] install problem

[Randall S. <ra...@tn...>]

I installed the oracle client 8.1.7 on Debian SID.  I have Python 
version 2.3.3 installed.  I downloaded 
cx_Oracle-4.0.1-8i-py23-1.i386.rpm and converted it to 
cx-oracle_4.0.1-2_i386.deb using Alient and installed it.  No errors 
appeared during the install.

This is the result:

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.8.0: cannot open shared object file: No such 
file or directory
 >>>

Any clues?

Randall

Re: [cx-oracle-users] install problem

[Anthony T. <an...@co...>]

Sounds to me like you're missing the Oracle client or it is not 
configured properly. Perform the following:

ldd cx_Oracle.so

and note the output. You may need to set the environment variable 
LD_LIBRARY_PATH to include $ORACLE_HOME/lib.

Randall Smith wrote:
> I installed the oracle client 8.1.7 on Debian SID.  I have Python 
> version 2.3.3 installed.  I downloaded 
> cx_Oracle-4.0.1-8i-py23-1.i386.rpm and converted it to 
> cx-oracle_4.0.1-2_i386.deb using Alient and installed it.  No errors 
> appeared during the install.
> 
> This is the result:
> 
> 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.8.0: cannot open shared object file: No such 
> file or directory
>  >>>
> 
> Any clues?
> 
> Randall
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] Re: install problem

[Andy T. <an...@ha...>]

Randall Smith wrote:
> I installed the oracle client 8.1.7 on Debian SID.  I have Python 
> version 2.3.3 installed.  I downloaded 
> cx_Oracle-4.0.1-8i-py23-1.i386.rpm and converted it to 
> cx-oracle_4.0.1-2_i386.deb using Alient and installed it.  No errors 
> appeared during the install.
> 
> This is the result:
> 
> 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.8.0: cannot open shared object file: No such 
> file or directory
>  >>>
> 
> Any clues?
> 
> Randall
> 

It looks like you've started Python from a session where the Oracle 
libraries are not in the path. Make sure your PATH environment variable 
contains $ORACLE_HOME/bin and that your LD_LIBRARY_PATH environment 
variable contains $ORACLE_HOME/lib

Of the two the second will fix your problem but the first is good 
practice and you should always set them as a pair.

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/