[mod_python] error connecting database oracle 9i

Nick nick at dd.revealed.net
Fri Jan 6 10:27:53 EST 2006


Well I just noticed that you're on windows, so the /etc/profile thing isn't 
going to help, but you may be able to set ORACLE_HOME in the environment 
variables for whatever user apache runs as on windows (I'm assuming you 
don't run it as SYSTEM; that's probably a bad idea).

Or my other suggestion should work fine for you.

Nick

Nick wrote:
> It's been a couple years since I worked with cx_Oracle in mod_python, I 
> believe I got around this problem by setting ORACLE_HOME in the global 
> /etc/profile.  But that was a much older version of cx_Oracle, and 
> ORACLE_HOME may have been statically compiled into the library.
> 
> You may be able to directly insert ORACLE_HOME into os.environ before 
> importing cx_Oracle.
> 
> Nick
> 
> python eager wrote:
> 
>>
>> Hi
>>   i trying to connect oracle 9i through python . While connecting i am 
>> facing follwing the error
>>
>> connection = cx_Oracle.connect("myusername", "mypassword", "mydatabase")
>>  RuntimeError: Unable to acquire Oracle environment handle
>>  
>> path of  ORACLE_HOME = 
>> C:\oracle\ora92\BIN;C:\PYTHON24;C:\WINDOWS\system32;C:\WINDOWS\System32\Wbem 
>>
>>  please solve this problem
>>
>> i am waiting for your reply
>>  
>> regards
>> Python _Eager
>>  
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Tired of spam? Yahoo! Mail has the best spam protection around
>> http://mail.yahoo.com
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Mod_python mailing list
>> Mod_python at modpython.org
>> http://mailman.modpython.org/mailman/listinfo/mod_python
> 
> 
> _______________________________________________
> Mod_python mailing list
> Mod_python at modpython.org
> http://mailman.modpython.org/mailman/listinfo/mod_python



More information about the Mod_python mailing list