Testing an Oracle DB connection before it is made – ERROR?

Posted on

Question :

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 ?

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.

Leave a Reply

Your email address will not be published. Required fields are marked *