Remote Oracle DB connection in python

Question

I want to connect to remote oracle db using python. Tried to using cx_Oracle.

Here is my code:

import cx_Oracle

adr = 'server_addres'
uid = 'user_id'
pwd = 'pwd'
port = 'port'

cx_Oracle.connect(uid + "/" + pwd + "@" + adr)

After execute, I am receiving error:

cx_Oracle.DatabaseError: ORA-12154: TNS: could not resolve the connect identifier specified

How to connect to my remote oracle db? Or maybe I should use something different than cx_Oracle?

I think this has already been answered here: stackoverflow.com/a/1870849/1917858 — Frans Henskens
– Frans Henskens, Commented May 17, 2018 at 4:49
I already tried this resolution, but it isn't working for me. Still the same error. — user6133328
– user6133328, Commented May 17, 2018 at 5:00
Ok, i found the reason. In my db address i put '//' at the begging. Now, after deleted '//' it works. So stackoverflow.com/a/1870849/1917858 works fine. Thanks. — user6133328
– user6133328, Commented May 17, 2018 at 5:07

Dipak Kale · Accepted Answer · 2022-11-23 05:23:43Z

0

import cx_Oracle conn = cx_Oracle.connect(user="User_id", password="User_password", dsn="the_ip_address/XE", encoding="UTF-8") print(conn.version) conn.close()

It gave me output as 18.0.0.0.0 which is my oracle version

answered Nov 23, 2022 at 5:23

Dipak Kale

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remote Oracle DB connection in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related