Monday, April 28, 2008

Microsoft.ServiceModel.Channels.Common.ConnectionException: ORA-1017: invalid username/password; logon denied

This is the first problem I had with the new oracle adapter pack.
From the error message, it is quite obvious right. But I was quite sure that I have provided the right user name and password.

I found the answer here, the user name / password may be case sensitive. After providing the user name and password with the appropriate case sensitivity, it is working now. hopla ;)

4 comments:

Anonymous said...

THANK YOU! We had the exact same issue, only the exception message read slightly differently:

Error occurred while browsing the LOB system. Adapter Message: ORA-1017: invalid username/password; logon denied

You already said this in your post, but I would emphasize again that the username is case-sensitive AS WELL AS the password. In our case, the username had to be ALL CAPS (matches the Oracle schema that was created around that user). This is counter-intuitive because all the clients I have ever used to connect to Oracle 9i and Oracle 10.2g have been case-insensitive on both username and password. This bizarre Visual Studio error message had put a huge roadblock in our dev efforts for using the WCF Oracle adapter. But your post has saved our bacon. Thank you for making my day! -- Robert Lewis

Bembeng Arifin said...

Hey Robert, glad that it helped ;)

Anonymous said...

Great Post!
Same problem, same solution.

If you think about the message...it's truth, the username is wrong.

Thank you.

James Zicrov said...

I feel SQL and other aspects really help to find more and more aspects and solutions to complex IT problems and looking for more solutions.

SQL Server Load Soap API

Post a Comment