[BangPypers] [HELP] Connectivity of Python with Oracle in Linux

[Diabolic Preacher]

Thank you for sharing the solution :)

On 4/25/08, Hussain Bohra <hussainbohra_30 at yahoo.com> 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 <shivraj.ms at gmail.com> 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/password at db_name')
> >>
> >> 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 at python.org
> >> http://mail.python.org/mailman/listinfo/bangpypers
> >
> >
> > _______________________________________________
> > BangPypers mailing list
> > BangPypers at 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 at python.org
> http://mail.python.org/mailman/listinfo/bangpypers
>
>
>
>  Thanks and Regards,
> Hussain Bohra
>
> HSBSoft Technologies,
> Bangalore-52
> mail-to:hussain.bohra at hsbsoft.com
> 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------