Oracle error
ORA-28000
ORA-28000: the account is locked
What usually causes it
Locked by an administrator or by too many failed logins under its profile.
What to check first
Find where the failed logins came from before unlocking, or the account will lock again.
Scripts that help
- Failed logins in the last 24 hoursFrom the unified audit trail, which records failed logons by default through the ORA_LOGON_FAILURES policy. Return code 1017 is a wrong password;…
- Unlock an account or reset its passwordChange the username and password before running. Quote the password so special characters are kept.
- Password profile settingsPassword rules for each profile: lifetime, reuse, failed attempts and the verify function. Shows why an account locked or expired.