ORA-01017: Invalid Username/Password; Logon Denied

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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.