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

[Jason B. <jb...@ze...>]

On Thu, Mar 18, 2010 at 11:52 PM, juhui <ph...@gm...> wrote:

> sorry, I said in django prjects.
> I have encounter this Traceback  several  dasys before .
> may be the  Python script can't  get the environment var  ORACLE_HOME
> add the two lines to your scripts ,the value depends on  you environment .
>

I believe the ORACLE_HOME variable is set properly.  I'm unable to reproduce
the issue when I log in to the server under the same user.  So I think it's
some kind of environment variable issue.  However, I don't seem to be able
to figure out what it is.  For reference, here are the environment variables
when I log in to the server myself:

HOSTNAME=inftest01
TERM=xterm
SHELL=/bin/bash
HISTSIZE=1000
KDE_NO_IPV6=1
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
USER=hudson
LS_COLORS=no=00:fi=00:di=00
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/../lib/i386:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib:
KDEDIR=/usr
PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin:/var/lib/hudson/usr/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin
MAIL=/var/spool/mail/hudson
TNS_ADMIN=/var/lib/hudson
PWD=/var/lib/hudson
INPUTRC=/etc/inputrc
KDE_IS_PRELINKED=1
LANG=en_US.UTF-8
PS1=\W
SQLPATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/var/lib/hudson
SHLVL=3
LOGNAME=hudson
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
G_BROKEN_FILENAMES=1
_=/bin/env

...I don't see anything there that should cause a problem.