Are you trying to connect to remote machine? (Try adding prefix IP to point to remote oracle machine)
Some debugging steps which I can think of if both were on same machine. tnsping <INSTANCE_NAME> set ORACLE_SID Log in through sqlplus Regards ___________ Shivaraj Rishabh Manocha wrote: > > I'm not very familiar with Oracle but a quick search on google for > ORA-12537 turned up > http://forums.oracle.com/forums/thread.jspa?messageID=1275528 > . Maybe it'll help > > Best, > > R > On 25-Apr-08, at 9:22 AM, Hussain Bohra wrote: > >> Hi All, >> >> 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 : >> >> 'export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/ >> db_1' (in .bashrc) >> >> In Python Machine we have added the entry of created database (in >> Oracle) in /etc/tnsnames.ora >> >> Now we are trying to connect like : >> >> import cx_Oracle >> cx_Oracle.connect('username/[EMAIL PROTECTED]') >> >> But Everytime getting an error : >> >> 'cx_Oracle.DatabaseError: ORA-12537: TNS Connection closed' >> >> We have tried to find the same in the google but we are unable to >> solve by the solutions provided there. >> >> Can any one suggest what is the problem. >> >> Regards, >> Hussain Bohra >> >> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. >> Try it now._______________________________________________ >> BangPypers mailing list >> BangPypers@python.org >> http://mail.python.org/mailman/listinfo/bangpypers > > > _______________________________________________ > BangPypers mailing list > BangPypers@python.org > http://mail.python.org/mailman/listinfo/bangpypers > > -- View this message in context: http://www.nabble.com/-HELP--Connectivity-of-Python-with-Oracle-in-Linux-tp16890308p16890703.html Sent from the BangPypers - Bangalore Python Users Group mailing list archive at Nabble.com. _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
