Hi All,<br><br>Thankx for your feedbacks.<br>We are able to solve the problem. The problem actually is the 'lsnrctl service' was not running in the $ORACLE_HOME/bin directory<br><br>the only thing to do is './$ORACLE_HOME/bin/lsnrctl start'<br><br>Regards,<br>Hussain Bohra<br><br><b><i>Shivaraj M S <shivraj.ms@gmail.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <br>Are you trying to connect to remote machine? (Try adding prefix IP to point<br>to remote oracle machine)<br><br>Some debugging steps which I can think of if both were on same machine.<br><br>tnsping <INSTANCE_NAME><br>set ORACLE_SID<br>Log in through sqlplus <br><br>Regards<br>___________<br>Shivaraj<br><br><br>Rishabh Manocha wrote:<br>> <br>> I'm not very familiar with Oracle but a quick search on google for <br>> ORA-12537 turned up<br>> http://forums.oracle.com/forums/thread.jspa?messageID=1275528
<br>> . Maybe it'll help<br>> <br>> Best,<br>> <br>> R<br>> On 25-Apr-08, at 9:22 AM, Hussain Bohra wrote:<br>> <br>>> Hi All,<br>>><br>>> We have a Oracle 10g Server in Linux, And we are using a Python <br>>> 2.2.2 (i.e. also in Linux). We are trying to connect with Oracle <br>>> using 'cx_Oracle'. The Environment Variable we have set in the <br>>> Oracle Machine is :<br>>><br>>> 'export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/ <br>>> db_1' (in .bashrc)<br>>><br>>> In Python Machine we have added the entry of created database (in <br>>> 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 <br>>> solve by the solutions provided there.<br>>><br>>> Can any one suggest what is the problem.<br>>><br>>> Regards,<br>>> Hussain Bohra<br>>><br>>> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. <br>>> Try it now._______________________________________________<br>>> BangPypers mailing list<br>>> BangPypers@python.org<br>>> http://mail.python.org/mailman/listinfo/bangpypers<br>> <br>> <br>> _______________________________________________<br>> BangPypers mailing list<br>> BangPypers@python.org<br>> http://mail.python.org/mailman/listinfo/bangpypers<br>> <br>> <br><br>-- <br>View this message in context: http://www.nabble.com/-HELP--Connectivity-of-Python-with-Oracle-in-Linux-tp16890308p16890703.html<br>Sent from the BangPypers - Bangalore Python Users Group
mailing list archive at Nabble.com.<br><br>_______________________________________________<br>BangPypers mailing list<br>BangPypers@python.org<br>http://mail.python.org/mailman/listinfo/bangpypers<br></INSTANCE_NAME></blockquote><br><BR><BR><div style="font-family: monotype corsiva; color: rgb(0, 0, 0); text-align: left;" id="RTEContent"> <div style="color: rgb(0, 0, 255); font-family: times new roman;"><font size="3">Thanks and Regards,<br>Hussain Bohra<br></font></div><font style="color: rgb(0, 0, 255); font-family: times new roman;" size="3">HSBSoft Technologies,<br>Bangalore-52<br>mail-to:<span style="text-decoration: underline;">hussain.bohra@hsbsoft.com</span><br></font><font style="text-decoration: underline; color: rgb(0, 0, 255); font-family: times new roman;" size="3">mobile : +91 99867 95727</font><br></div><p> 
<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>