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

Brought to you by: atuining

cx-oracle-users

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

From: M. A. W. <maw...@gm...> - 2006-10-16 07:41:33

Hi All,

i  am executing python script as cgi, path of this script is in html page
but got error
RuntimeError: Unable to acquire Oracle environment handle

 (i solve this error , but not sure is this proper way)

funny thing is
i used sqlplus  "user/password@connection"
 it worked fine
got sql> prompt


then  i wrote a script file test.py

import cx_Oracle
db = cx_Oracle.connect("user/password@connection")
cur = db.cursor()
cur.execute("select * from emp")
r = cur.fetchall()
for i in r:
 print i


it also worked fine,  i thought my environment is proper.


then i wrote cgi-script

#!/usr/bin/python
print 'content-type: text/html','\n';
import cgi
import sys
import cx_Oracle
import os
sys.stderr = sys.stdout
db = cx_Oracle.connect('mukhtar/mukhtar@navi')

but got error on browser (RuntimeError: Unable to acquire Oracle environment
handle )

then explicitly I set  ORACLE_HOME in script itself, it worked

#!/usr/bin/python
print 'content-type: text/html','\n';

import cgi
import sys
import cx_Oracle
import os
sys.stderr = sys.stdout
os.putenv('ORACLE_HOME','/u01/app/oracle/product/9.2.0')  # i just add this
line,
db = cx_Oracle.connect('mukhtar/mukhtar@navi')


but got confused it ORACLE_HOME is set and working with normal script, why
i need to put this line in cgi-script

Thanks in Advance,
Mukhtar

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

From: Bartosz S. <get...@gm...> - 2008-11-27 16:42:19

Hi,

I know that this problem is quite often and I found 1000 answers but
in fact all of them are the same. And my issue is still here.

Because my admin is not as good as he should, and nothing work as it
should, i try to fix it on my own hand, so.....


Admin installed Oracle Instant Client basic 10.2.0.4 (our remote
Oracle database has the same version), and he installed it here:
[bartek@batman ~]$ rpm -ql oracle-instantclient-basic-10.2.0.4-1
/usr/lib/oracle/10.2.0.4/client/bin/genezi
/usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1
/usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
/usr/lib/oracle/10.2.0.4/client/lib/libocci.so.10.1
/usr/lib/oracle/10.2.0.4/client/lib/libociei.so
/usr/lib/oracle/10.2.0.4/client/lib/libocijdbc10.so
/usr/lib/oracle/10.2.0.4/client/lib/ojdbc14.jar
[bartek@batman ~]$

Also, i found this:
[bartek@batman ~]$ ls -R /usr/lib/oracle/10.2.0.3/
/usr/lib/oracle/10.2.0.3/:
client

/usr/lib/oracle/10.2.0.3/client:
bin  lib

/usr/lib/oracle/10.2.0.3/client/bin:

/usr/lib/oracle/10.2.0.3/client/lib:
[bartek@batman ~]$

But it's empty.

Ok, I downlaoded cx_Oracle 4.3.1 Fedora Core 5 RPM (Oracle 10g, Python
2.5) [1], unpacked it and made a quick hack:
[bartek@batman ~]$ ls usr/local/lib/python2.5/st/
cx_Oracle-4.3.1-py2.5.egg-info  cx_Oracle.so  __init__.py  __init__.pyc
[bartek@batman ~]$

By default there are not any $ORACLE_* neither $TNS_ADMIN.

[bartek@batman python2.5]$ python
Python 2.5.1 (r251:54863, Nov 15 2007, 09:48:39)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-8)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import st.cx_Oracle as cx
>>> cx.__file__
'st/cx_Oracle.so'    # as you see, we imported correct module
>>> cx.version
'4.3.1'
>>> dsn = cx.makedsn(remote_ip, 1521, my_sid)
>>> conn = cx.connect(l, p, dsn)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
RuntimeError: Unable to acquire Oracle environment handle
>>>


I tried to add the following before importing cx_Oracle:
os.environ['PATH'] = '/usr/lib/oracle:' + os.environ['PATH']
os.environ['ORACLE_HOME'] = '/usr/lib/oracle'
os.environ['LD_LIBRARY_PATH'] = '/usr/lib/oracle'

nothing has changed. Also tried to set those vars to
/usr/lib/oracle/10.2.0.4/client/lib but no results

anyone can help me?
bart.


[1] I tried the latest version but i get this:
ImportError: libpython2.5.so.1.0: cannot open shared object file: No
such file or directory