Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I tried to make a new oracle DB connection with user name and password. I entered the connection name, user name and password in the new connection window. When I click the "test" button or the "connect" button, I get the following error: Status : Failure - Test Failed: ORA-01017: invalid username/password; logon denied

Why am I getting this error ? What does the Test & Connect button actually do ?

share|improve this question
    
Note- I found that one reason for this error is setting username = user. That's NOT allowed. –  sweet dreams Aug 6 '12 at 21:05
    
The error still remains. –  sweet dreams Aug 6 '12 at 21:32
    
You're talking about a test button in a program we could guess but it might be wrong and the answer, useless... where are you setting the connection? Also, the error is not being raised before making the connection because you're trying to connect to the DB and perform a select 1 from dual. –  Alfabravo Aug 7 '12 at 0:12
add comment

migrated from stackoverflow.com Aug 8 '12 at 1:30

This question came from our site for professional and enthusiast programmers.

1 Answer

The error is telling your user login username or password is incorrect. Remember that from 11g onwards, passwords are case sensitive.

The test & connect button tests if the entered details (TNSName, port etc) are correct & then proceeds to connect to the database. In your case, your credentials are wrong & you're getting the error message.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.