Re: [cx-oracle-users] cx_Oracle.InterfaceError: Unable to acquire Oracle environment handle

[sara b. <sar...@gm...>]

**<http://research.microsoft.com/en-us/um/people/lamport/pubs/lamport-mutual-solved.ps>The
problem has been solved. something wrong with my LD_LIBRARAPATH
changed it into
LD_LIBRARY_PATH=.:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib


sorry for disturb  *

**

*
2010/8/16 sara bai <sar...@gm...>

> hi :
>
>  I got this error :
>  db = cx_Oracle.connect('sara', 'pswd', '192.168.1.100:1521/test_db')
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> cx_Oracle.InterfaceError: Unable to acquire Oracle environment handle
>
>
> here is part of my .bashrc file   at /home/sara/.bashrc
>
> export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
>
> export PATH=$PATH:$ORACLE_HOME/bin
>
> export ORACLE_SID=XE
>
> export LD_LIBRARY_PATH=.:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
>
> export SQLPATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus
>
>
> --------------------------------------------------------------------------------------
> when run sqlplus in cmd line
>
> $ sqlplus
>
> SP2-1503: Unable to initialize Oracle call interface
> SP2-0152: ORACLE may not be functioning properly
>
> -----------------------------------------------------
>
> /usr/lib/oracle/xe/app$ ll
>
> drwxrwxrwx 6 oracle dba 4096 2010-08-16 13:07 oracle
> -----------------------------------------------------------
>
> echo $PATH
>
> /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/bin/X11:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin
>
>
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib$ ls
>
> libclntsh.so       libheteroxa10.so  libocci.so       libocijdbc10.so
> libsqlplusic.so  libsqora.so.10.1
> libclntsh.so.10.1  libnnz10.so       libocci.so.10.1  libocixe.so
> libsqlplus.so
>
>
>
>
>
> i don't konw what's wrong with my cx_Orcale .  need help ,thank you
>
>
>
>
>