All Oracle errors
ORA-28000security

Account is locked

ORA-28000: the account is locked

Why it happens

Too many failed logins hit the FAILED_LOGIN_ATTEMPTS profile limit, or a DBA locked the account on purpose.

How to fix it

A DBA unlocks it (ALTER USER user ACCOUNT UNLOCK), resets the password, and raises the profile limit if the lock outs are from a misplaced app password.

A note on ORA-28000

This entry is part of a hand-curated set of ORA-, FRM-, REP- and TNS- codes that actually turn up in production Oracle estates — SQL*Plus, APEX, 19c/21c, ODP.NET apps, Oracle Forms 6i/12c and Reports included. The message text above is the canonical wording; the cause and fix are written in plain language so a developer or DBA can act without digging through pages of Oracle reference docs first.

Codes outside this list of 44 are far less common. If you hit one, the official Oracle error reference and your instance's alert or listener log remain the authoritative source.

Build custom software with us

From internal tools to full platforms — we deliver end to end.

Was this tool useful?