ORA-01017 🗃️ SQL

ORA-01017: invalid username/password; logon denied

Oracle rejected the credentials.

Seen on: SQL

Meaning

Passwords are case-sensitive since 11g; also check you’re connecting to the right service/PDB, and that the account isn’t locked/expired (ORA-28000/28001).

Common causes

  • Wrong password or case
  • Wrong service name (CDB vs PDB)
  • Old client vs new password verifier versions

⚡ Quick fix

  1. Reset the password
  2. Connect to the correct PDB service
  3. Check account_status in dba_users

Detailed fix by platform

SQL

  1. ALTER USER app IDENTIFIED BY "NewPass1" ACCOUNT UNLOCK;

How to diagnose

  1. Account — Locked/expired?
  2. Service — Right PDB?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.