Connecting to remote Oracle db via Python

[Anurag Chourasia]

Apart from that, you could also use a shorter format which is a
correction over what you were trying with earlier.

Here......

uid = "scott"
pwd = "tiger"
service = "//10.5.1.12:1521/PR10"
db = cx_Oracle.connect(uid + "/" + pwd + "@" + service)

Please let us know how it goes.

Regards,
Anurag

On Thu, Feb 17, 2011 at 8:28 PM, Anurag Chourasia
<anurag.chourasia at gmail.com> wrote:
> Try this please and it should work.
>
> Connection_String =
> 'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.5.1.12)(PORT=1521)))(CONNECT_DATA=(SID=PR10)))'
>
> db = cx_Oracle.connect(Connection_String)
>
> I'm sorry i missed a bracket there.
>
> Regards,
> Anurag
>
>
> On Thu, Feb 17, 2011 at 8:18 PM, Paul Statham <PStatham at sefas.com> 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=10.5.1.12(PORT=1521)))(CONNECT_DATA=(SID=PR10)))'
>>
>> db = cx_Oracle.connect(Connection_String)
>>
>> Regards,
>> Anurag
>>
>> On Thu, Feb 17, 2011 at 4:10 PM, pstatham <pstatham at sefas.com> 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)
>>>
>>>>>> uid = "scott"
>>>>>> pwd = "tiger"
>>>>>> service = "10.5.1.12:1521:PR10"
>>>>>> db = cx_Oracle.connect(uid + "/" + pwd + "@" + service)
>>>
>>> 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)
>>>
>>>>>> service = "jdbc:oracle:thin:@10.5.1.12:1521:PR10"
>>>>>> db = cx_Oracle.connect(uid + "/" + pwd + "@" + service)
>>> 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
>>>
>>
>>
>>
>