[Python] Connecting to remote Oracle db via Python

On Thu, Feb 17, 2011 at 4:10 PM, pstatham wrote:
Hi Guys,

I've installed the cx_Oracle module for Python and I'm trying to
connect to my remote Oracle db. Like so (username, password and ip
below aren't real don't worry)
This however gives me the following error:

Traceback (most recent call last):
?File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-12545: Connect failed because target host
or object
?does not exist

I've also tried the following (jdbc string which works fine for java)
Traceback (most recent call last):
?File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect
identifier
?specified

I'm not sure what's going on because I know that the ip, port and
service name. are correct? And as I said I can connect to it via JDBC
in Java.

Any ideas?

Thanks,
Paul
--
http://mail.python.org/mailman/listinfo/python-list

On Thu, Feb 17, 2011 at 8:18 PM, Paul Statham wrote:
Doesn't seem to work

-----Original Message-----
From: Anurag Chourasia [mailto:anurag.chourasia at gmail.com]
Sent: 17 February 2011 14:41
To: Paul Statham
Cc: python-list at python.org
Subject: Re: Connecting to remote Oracle db via Python

Could you try by using a connecting string in the standard format as below?

Connection_String > 'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST.5.1.12(PORT21)))(CONNECT_DATA=(SID=PR10)))'

db = cx_Oracle.connect(Connection_String)

Regards,
Anurag

Try this please and it should work.

Connection_String > 'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST.5.1.12)(PORT21)))(CONNECT_DATA=(SID=PR10)))'

db = cx_Oracle.connect(Connection_String)

I'm sorry i missed a bracket there.

Regards,
Anurag