SQL Server ORA-01017: invalid username/password; logon denied when connecting to OracleDB through SSMA

bjp0bcyl 于 2023-04-10 发布在 Go

关注(0)|答案(1)|浏览(115)

ORA-01017: invalid username/password; logon denied

We are currently migrating the contents of Oracle DB to SQL Server.

I'm using SSMA 9.3v and I have Oracle 11g to connect to.

You have installed the Oracle 11.2 client for the connection and are in the process of accessing ODP.net .
ORA-01017: invalid username/password; login denied status after login information is accessed.

CMD confirmed that the connection through SQLPLUS is successful.

Both Standard mode and TNS mode have the same problem

Do you happen to know a solution to this error?

sql-server

来源：https://stackoverflow.com/questions/75945169/ora-01017-invalid-username-password-logon-denied-when-connecting-to-oracledb-t

1条答案

按热度按时间

fnx2tebb1#

"ORA-01017: invalid username/password" is a "good result", in the sense that it means you successfully contacted a database, and it understood your request.

So what this means is, one of the following:

a) you have contacted the wrong database. This might be "indirectly" wrong. For example, if you are using a entry from a tnsnames.ora file then you might be pointing at the wrong file.

b) your username is wrong.

c) your password is wrong (passwords are typically case-sensitive depending on your settings).

赞(0）回复(0）举报 2023-04-10

我来回答

SQL Server ORA-01017: invalid username/password; logon denied when connecting to OracleDB through SSMA

1条答案

相关问题

热门标签

最新问答