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

[Shivaraj M S]

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/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.