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

[Hussain Bohra]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/bangpypers/attachments/20080425/abbc1fe3/attachment.htm>