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

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

My continuous integration server is getting a weird error that I haven't
seen before:

Traceback (most recent call last):
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/lib/python2.6/site-packages/multiprocessing-2.6.2.1-py2.6-linux-i686.egg/multiprocessing/process.py",
line 237, in _bootstrap
    self.run()
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/jiva_interface/process/__init__.py",
line 150, in run
    self.main()
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/jiva_interface/interface_core/row_loader.py",
line 239, in main
    store = create_store(self.cfg, name=self.name)
  File "build/bdist.linux-i686/egg/dbkit/connect.py", line 127, in
create_store
    return _make_store(db_cfg, name, zstore_util)
  File "build/bdist.linux-i686/egg/dbkit/connect.py", line 168, in
_make_store
    store = zstore_util.create(name, uri)
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/lib/python2.6/site-packages/storm-0.16.0-py2.6-linux-i686.egg/storm/zope/zstorm.py",
line 133, in create
    store = Store(database)
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/lib/python2.6/site-packages/storm-0.16.0-py2.6-linux-i686.egg/storm/store.py",
line 72, in __init__
    self._connection = database.connect(self._event)
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/lib/python2.6/site-packages/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py",
line 381, in connect
    return self.connection_factory(self, event)
  File
"/var/lib/hudson/jobs/jiva_interface_trunk/workspace/lib/python2.6/site-packages/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py",
line 182, in __init__
    self._raw_connection = self._database.raw_connect()
  File "build/bdist.linux-i686/egg/storm_oracle/oracle.py", line 578, in
raw_connect
    self._password, self._dsn)
InterfaceError: Unable to acquire Oracle environment handle

I've done a basic google search, and found that this is usually a mismatch
of some kind between the ORACLE_HOME and LD_LIBRARY_PATH.  That doesn't seem
to be the case right now.  The variables that I have set are coming from
$ORACLE_HOME/bin/oracle_env.sh.  I've tried it with both 5.0.2 and 5.0.3,
and I still get the same thing.  Here are the environment variables I'm
using (with all the sensitive ones taken out):

BUILD_URL=http://192.168.2.27:8080/job/jiva_interface_trunk/62/
HOSTNAME=inftest01
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
KDE_NO_IPV6=1
BUILD_TAG=hudson-jiva_interface_trunk-62
JIVA_DB_PLATFORM=oracle
WORKSPACE=/var/lib/hudson/jobs/jiva_interface_trunk/workspace
JOB_URL=http://192.168.2.27:8080/job/jiva_interface_trunk/
USER=hudson
ORACLE_DSN_NAME=oradev
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
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:
NO_BULK=True
KDEDIR=/usr
NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat
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
TNS_ADMIN=/var/lib/hudson
MAIL=/var/spool/mail/hudson
INPUTRC=/etc/inputrc
PWD=/var/lib/hudson/jobs/jiva_interface_trunk/workspace
HUDSON_URL=http://192.168.2.27:8080/
LANG=en_US.UTF-8
KDE_IS_PRELINKED=1
JOB_NAME=jiva_interface_trunk
XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt
BUILD_ID=2010-03-18_08-48-40
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=2
SRV_ROOT=/srv/www/lighttpd/
EXECUTOR_NUMBER=0
LOGNAME=hudson
HUDSON_HOME=/var/lib/hudson
LESSOPEN=|/usr/bin/lesspipe.sh %s
BUILD_NUMBER=62
HUDSON_COOKIE=25e5918c-dd84-4f59-b1f2-97104c386a0d
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
G_BROKEN_FILENAMES=1
_=/bin/env

Is there anything here that might cause a problem?