Blog

Learnomate Technologies > Blog > Oracle DBA > ORA-01017: Invalid Username/Password; Logon Denied

ORA-01017: Invalid Username/Password; Logon Denied

  • January 24, 2020
  • Posted by: Ankush Thavali
  • Category: Oracle DBA
No Comments

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.
ora 01017 error in oracle 12c ORA-01017 ora-01017 invalid username/password logon denied 12c sysdba ora-01017 invalid username/password logon denied 12cr2 ora-01017 invalid username/password logon denied oracle 10g ora-01017 invalid username/password logon denied sql developer ora-01017 invalid username/password logon denied sysdba ORA-01017: Invalid Username/Password; Logon Denied ora-01017: invalid username/password; logon denied 18c