1

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 ?

Improve this question
3
  • Note- I found that one reason for this error is setting username = user. That's NOT allowed.
    – sweet dreams
    Commented Aug 6, 2012 at 21:05
  • The error still remains.
    – sweet dreams
    Commented Aug 6, 2012 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
    Commented Aug 7, 2012 at 0:12

1 Answer 1

Reset to default
1

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.