Thank you for sharing the solution :) On 4/25/08, Hussain Bohra <[EMAIL PROTECTED]> wrote: > Hi All, > > Thankx for your feedbacks. > We are able to solve the problem. The problem actually is the 'lsnrctl > service' was not running in the $ORACLE_HOME/bin directory > > the only thing to do is './$ORACLE_HOME/bin/lsnrctl start' > > Regards, > Hussain Bohra > > Shivaraj M S <[EMAIL PROTECTED]> wrote: > 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 > 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 > > > > Thanks and Regards, > Hussain Bohra > > HSBSoft Technologies, > Bangalore-52 > mail-to:[EMAIL PROTECTED] > mobile : +91 99867 95727 > > > > --------------------------------- > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it > now.
-- Diabolic Preacher As Is Blog: http://pintooo15.livejournal.com/ Bookmarks: http://simpy.com/user/dpreacher -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCS/IT d+(-) s+:+ a22 C++@ UL@ P L+(++) E- W++ !N o? K>++ w(-) !O M-(--) !V PS+ PE++ Y+ PGP t- 5? X>+ R- tv@ b-(+) DI+ D+ G++ e++ h-- !r y- ------END GEEK CODE BLOCK------ _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
