ORA-01017: Invalid Username/Password; Logon Denied

• 24 Jan, 2020
• 0 Comments
• 24 Secs Read

ORA-01017: Invalid Username/Password; Logon Denied

While you try to connect to database then most probably you will find the ORA-01017 error.

Problem Statement

ORA-01017: Invalid Username/Password; Logon Denied

Solution

1. Check if you have set up the right ORACLE_HOME and ORACLE_SID
2. Check the entry for your tnsnames.ora and listener.ora file. there should not be any typo error.
3. If you set SEC_CASE_SENSITIVE_LOGON parameter set to true then make sure to use correct case.
4. Start the oracle services before you connect to database.