471,602 Members | 1,296 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,602 software developers and data experts.

error rising while connecting oracle 9i

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
2 3339
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
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.

Similar topics

1 post views Thread by Paul | last post: by
2 posts views Thread by rcc.gamer | last post: by
4 posts views Thread by alegria4ever | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.