Master in Oracle DBA | Join us for the demo session on 19th November 2025 at 7:00 PM IST

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 AvatarKiran Dalvi
  • 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.

Let's Talk

Find your desired career path with us!