Greg Lindstrom wrote: > Hello, > > I'm trying to help out a friend and am stumped. Can you help me out? > Thanks, > --greg >
Hi Greg, I fought with this for a long, long time when I was trying to get cx_Oracle to work with the latest Oracle Instant Client (which I like to call "Oracle Instant Crap") on Solaris 10. It was a while ago and it I tried a lot of things, but I think it ended up getting fixed when I properly set my $TNS_ADMIN variable so it could find my tnsnames.ora file, since it's in a non-standard location wrt $ORACLE_HOME in the Instant Crap. If that doesn't do it, I afraid I don't know what else to suggest. My pertinent oracle environment settings look like this: LD_LIBRARY_PATH=/usr/local/lib:/usr/sfw/lib:/opt/sfw/lib:/lib:/usr/lib:/usr/local/oracle:/usr/local/ssl/lib:/usr/local/mysql/lib/mysql:/wb/lib/oracle ORACLE_HOME=/usr/lib/oracle ORACLE_SID=PROD_ORA01 TNS_ADMIN=/usr/lib/oracle Note: tnsnames.ora lives in /usr/lib/oracle on my system, TNS_ADMIN just refers to the directory. Hope that helps, e. > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > I will briefly explain the problem I am facing. > I am using Oracle 9.2, Python 2.5 and I installed > cx_Oracle-4.3.1-win32-9i-py25 in Python. > > From python I tried following : > >>> import cx_Oracle > >>> myDsn = cx_Oracle.makedsn('ISCN47',1521,'AUBDBS01') > >>> CONN = cx_Oracle.connect(myusr, mypwd, myDsn) > Traceback (most recent call last): > File "<pyshell#4>", line 1, in <module> > conn = cx_Oracle.Connection('scott','tiger',myDsn) > RuntimeError: Unable to acquire Oracle environment > handle > > I have set the below environment variables too > NLS_LANG: <snip>.WE8MSWIN1252 > ORACLE_HOME: D:\Tools\oracle\ora92 > ORACLE_SID: AUBDBS01 > PYTHON_HOME: d:\Utility\Python25 > PYTHONPATH: > %PYTHON_HOME%\lib;%PYTHON_HOME%\DLLs;%PYTHON_HOME%\Lib\site-packages;%ORACLE_HOME%\bin > LD_LIBRARY_PATH: %LD_LIBRARY_PATH%;D:\Tools\oracle\ora92\lib > > Not getting any idea where I am wrong? > > Regards, > > Kishore > ------------------------------------------------------------------------ > > _______________________________________________ > Tutor maillist - Tutor@python.org > http://mail.python.org/mailman/listinfo/tutor > _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor