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

[sara b. <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