我試圖在一個Python腳本中連接到2個Oracle數(shù)據(jù)庫，但是在連接到第二個數(shù)據(jù)庫時遇到了一些麻煩。我收到的錯誤是：“ DatabaseError：ORA-01017：無效的用戶名/密碼；登錄被拒絕”我的登錄信息是正確的，所以我對為什么不允許我訪問第二個數(shù)據(jù)庫感到困惑。任何見解將不勝感激。示例代碼如下：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)
1 回答
慕標5832272
TA貢獻1966條經(jīng)驗 獲得超4個贊
你犯了一個錯誤 dsn=dsnStr
dsnStr2 = cx_Oracle.makedsn("database2", "port_for_db2", "sid_for_db2")
conn2 = cx_Oracle.connect("myusername","password_db2",dsn=dsnStr2)添加回答
舉報
0/150
提交
取消