CODEWITHSUNDEEP
oracle-databaseoracle-sqldevelopersqlplus
vera yang
vera yang

Reputation: 1

Oracle SQL Developer Create new connection Error message: Test failed: ORA-01017: invalid username/password; logon denied

I'm trying to create a new connection in SQL Developer (following homework's instructions), as requested I have filled in the information, but it keep reporting error message when I tried Test and Status shows this error message:

Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied

enter image description here

I searched and some people said should go to TNSNAMES.ORA file look for names and password, but I don't see my TNSNAMES.ORA file has these information enter image description here enter image description here

Below is what the instruction asks: enter image description here

I have tried to just come up with the name at the beginning and getting the message, and also search names and password in the TNSNAMES.ORA file but find nothing, not sure how I can get the correct username and password here. Please indicate the steps of how to find the correct username and password if you know, and it has to be tested and show status success. Thank you

Upvotes: 0

Views: 4157

Answers (1)

Connor McDonald
Connor McDonald

Reputation: 11586

This is a not a tnsnames.ora problem.

If you get ORA-1017 it means you successfully made contact with the database, ie, the database is open, it is responding to requests via the listener. Everything is working fine.

However, your username or password is incorrect which is why you cannot get onto the database.

One cause might be because you have chosen SYSDBA as the connection type - I suspect that GENUSER is a normal user not a SYSDBA, so change that.

Also, passwords are case sensitive so double check that as well.

Upvotes: 1

Related Questions