5 Replies Latest reply: May 19, 2011 1:10 AM by 862974 RSS

    cx_Oracle.InterfaceError:unable to acquire envirnoment handle

    789319
      Hi all,
      I am facing this issue with cx_Oracle error like cx_Oracle.InterfaceError:unable to acquire envirnoment handle
      using cx_Oracle for windows platform with python version 2.6 . i haved dowload the cx_Oracle with version cx_Oracle-5.0.4-10g win32 py26.msi which is in binary and installed.
      Inside the python folder LIB/site packages i found cx_Oracle.pyd file was present with help of this i am able to import the cx_oracle from python prompt

      >>import cx_Oracle
      This is working fine and its is importing but whenl i am trying to connect to the database through this
      >>cx_Oracle.connect()
      also with >>cx_Oracle("abc/abc@ORCL")
      Traceback <most recent call last>
      file "<stdin">,line 1 in <module>
      cx_Oracle.InterfaceError:unable to acquire envirnoment handle --> ii am facing this issue i have set the environment path of ORACLE_HOME but still i am facing this issue not able to connect to database

      The same which works fine with instanclient version 10.2 without python i am able to connect to database with help of cx_Oracle.connect() but its not same in the python prompt
      as i have set all path but still i am facing this issue.

      i am using instantclient10g version
      os:32bit machine both xp & server2003
      location cx_Oracle i downloaded: http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.0.4-10g-unicode.win32-py2.6.msi?download

      let me know if any more path or dll i have to include in the python folder





      regards
      pavanbabu

      Edited by: user11419695 on Aug 4, 2010 5:02 AM