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

[juhui <ph...@gm...>]

try add
--------------
import os
os.environ["ORACLE_HOME"] = "/home/oracle/product/10.2.0"
--------------
to setting.py header.


2010/3/18 Jason Baker <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?
>
>
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>


-- 
LB can FlY