By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,353 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,353 IT Pros & Developers. It's quick & easy.

error rising while connecting oracle 9i

P: n/a
Hi
i am connecting my database oracle 9i. While connecting i am
getting the following error

connection = cx_Oracle.connect("myusername", "mypassword", "python")
RuntimeError: Unable to acquire Oracle environment handle
please send the solution

Thank you
regards
Python Eager


Jan 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
python_eager wrote:
Hi
i am connecting my database oracle 9i. While connecting i am
getting the following error

connection = cx_Oracle.connect("myusername", "mypassword", "python")
RuntimeError: Unable to acquire Oracle environment handle

Do you have the Oracle client installed? Might be something wrong with
your ORA_HOME.

Robert

Jan 7 '06 #2

P: n/a
Check:
1. Whta is the Python version your running, with
py> import sys
py> print sys.version
2.4.2 (#2, Sep 30 2005, 21:19:01)
[GCC 4.0.2 20050808 (prerelease) (Ubuntu 4.0.1-4ubuntu8)]
2. Download the correct version of cx_Oracle
see http://www.cxtools.net/default.aspx?nav=cxorlb
then execute the command again - supposed your user is "myusername",
your assword is "mypassword", and your dsn is "python".

The dns should match an entry in the 'tnsnames.ora' - the location of
this file depends on running Oracle on a Windows or Unix server.

If you need more help please post more info like:
* Oracle version (including subnumbers)
* Python version
* cx_Oracle version
* OS version
* DNS entry
* exact traceback

Jan 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.