<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I'm not very familiar with Oracle but a quick search on google for ORA-12537 turned up <a href="http://forums.oracle.com/forums/thread.jspa?messageID=1275528">http://forums.oracle.com/forums/thread.jspa?messageID=1275528</a>. Maybe it'll help<div><br class="webkit-block-placeholder"></div><div>Best,</div><div><br class="webkit-block-placeholder"></div><div>R<br><div><div>On 25-Apr-08, at 9:22 AM, Hussain Bohra wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi All,<br><br>We have a Oracle 10g Server in Linux, And we are using a Python 2.2.2 (i.e. also in Linux). We are trying to connect with Oracle using 'cx_Oracle'. The Environment Variable we have set in the Oracle Machine is : <br><br>'export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1' (in .bashrc)<br><br>In Python Machine we have added the entry of created database (in Oracle) in /etc/tnsnames.ora<br><br>Now we are trying to connect like : <br><br>import cx_Oracle<br>cx_Oracle.connect('username/password@db_name')<br><br>But Everytime getting an error : <br><br>'cx_Oracle.DatabaseError: ORA-12537: TNS Connection closed'<br><br>We have tried to find the same in the google but we are unable to solve by the solutions provided there.<br><br>Can any one suggest what is the problem.<br><br>Regards,<br>Hussain Bohra<br><div> <br class="webkit-block-placeholder"></div><hr size="1">Be a better friend, newshound, and know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>_______________________________________________<br>BangPypers mailing list<br><a href="mailto:BangPypers@python.org">BangPypers@python.org</a><br>http://mail.python.org/mailman/listinfo/bangpypers<br></blockquote></div><br></div></body></html>