Connect to 2 Oracle Databases in Python

Question

I am trying to connect to 2 Oracle databases in a single Python script and am having some trouble connecting to the second database. The error I am receiving is:

"DatabaseError: ORA-01017: invalid username/password; logon denied"

My login information is correct so I am confused on why it is not allowing me to access the second database. Any insight would be appreciated.

Sample code below:

dsnStr = cx_Oracle.makedsn("database1", "port_for_db1", "sid_for_db1") 
conn = cx_Oracle.connect("myusername","password_db1",dsn=dsnStr)  

dsnStr2 = cx_Oracle.makedsn("database2", "port_for_db2", "sid_for_db2") 
conn2 = cx_Oracle.connect("myusername","password_db2",dsn=dsnStr)

Thank you!

try to connect it other database applications, like dbeaver or Navicat — utks009
– utks009, Commented Aug 22, 2018 at 13:47

Dmitry Demin · Accepted Answer · 2018-08-22 15:18:28Z

2

You made a mistake dsn=dsnStr

  dsnStr2 = cx_Oracle.makedsn("database2", "port_for_db2", "sid_for_db2") 
    conn2 = cx_Oracle.connect("myusername","password_db2",dsn=dsnStr2)

answered Aug 22, 2018 at 15:18

Dmitry Demin

2,1332 gold badges19 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Connect to 2 Oracle Databases in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related