Skip to main content
  1. Archives/

Troubleshooting Oracle’s ORA-01017 errors

··221 words·2 mins·
Programming Oracle

Was writing this for Stack Overflow‘s tag wiki on ORA-01017, thought I’ll post it here as well.

ORA-01017 is the error code shown my Oracle when a login attempt to the database was not successful.

The full text of the error code is:

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to

log on to Oracle. The username and password must be the same as was

specified in a GRANT CONNECT statement. If the username and password

are entered together, the format is: username/password.

Action: Enter a valid username and password combination in the correct


DBA-Oracle has a checklist for ORA-01017 errors. Though the core problem is incorrect credentials, the reason for incorrect credentials maybe one of the below:

  •  The user id may not be present in the target system
  • $ORACLE_SID maybe incorrectly defined, leading to a connection attempt to a wrong system
  • tnanames.ora points to an incorrect instance

Also, if you upgraded a pre-Oracle 11g instance to Oracle 11g & above, you might start encountering ORA-0107 messages. The reason is that Oracle 11g & above by default support case sensitive passwords, as opposed to previous versions where all passwords were set to upper case.

This behavior can be set to status quo by using SEC_CASE_SENSITIVE_LOGON parameter, as explained by Mark Williams.

Sathyajith Bhat
Sathyajith Bhat
Author, AWS Container Hero and DevOps Specialist.


10 minute bug fixes & web conference bloopers
··528 words·3 mins
Programming Humor
Came across this article via HN and I’m pretty sure most who work for Enterprise companies would’ve come across this at least once. Incredibly detailed post. Boss: Hey Ed, Sue in Detroit says that sometimes, the wrong Invoice Part Number is showing up on the Product History Screen. Can you help us figure this out. Ed: I’m busy with something else at the moment. Put the ticket in my queue.
SSH into your servers from Unity using unity-sshsearch-lens
··120 words·1 min
Tips & How-To's Ubuntu
I love Unity, especially the lens feature. While going through the Ubuntu store, found this neat little lens for initiating an SSH connection. The lens parses your ~/.ssh/known_hosts & ~/.ssh/config files and provides you with a list of servers that you can connect to. Just install the lens, logout & login back to your desktop and you're good to go. To search, just bring up Unity dash by hitting the Super (aka Windows) key, type either the username or host and just hit enter to initiate the connection.