ORA Error ReferenceSearch errors

All errors › ORA errors

ORA-01017: Invalid username/password; logon denied

What it means

The credentials were rejected. Since 11g passwords are case-sensitive; the user may also be connecting to the wrong service/PDB, or the password file / OS authentication is not set up.

How to fix it

Check the case of the password, the service name and PDB, and whether the account exists (DBA_USERS). Quote passwords containing special characters. On newer versions also check the client/server authentication protocol (see ORA-28040).

Catch it before it runs

ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip.
PL/SQL Lint
Flags risky PL/SQL patterns while you type.
Oracle Plan Reader
Reads execution plans and points at the slow step.
PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.

Nearby errors

Updated 2026-11-12.