[BangPypers] [HELP] Connectivity of Python with Oracle in Linux
Shivaraj M S
shivraj.ms at gmail.com
Fri Apr 25 07:17:21 CEST 2008
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.
Log in through sqlplus
Rishabh Manocha wrote:
> I'm not very familiar with Oracle but a quick search on google for
> ORA-12537 turned up
> . Maybe it'll help
> 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.
>> Hussain Bohra
>> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
>> Try it now._______________________________________________
>> BangPypers mailing list
>> BangPypers at python.org
> BangPypers mailing list
> BangPypers at python.org
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.
More information about the BangPypers