Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

DIA-28000

The account is locked; login denied.

Cause

This occurs when any of the following are true:

  • Incorrect credentials were used for too many consecutive failed login attempts.
  • The account was locked by an administrator.
  • The user was a common user locked in the root container.

Action

Wait for the PASSWORD_LOCK_TIME to elapse before retrying, or contact the DBA to unlock the account manually using the ALTER USER command with the ACCOUNT UNLOCK clause. The PASSWORD_LOCK_TIME is the password profile limit which specifies how long the account remains in the LOCKED(TIMED) status after the wrong credential was used for FAILED_LOGIN_ATTEMPTS consecutive login attempts. A user's account status can be found in the ACCOUNT_STATUS column of the DBA_USERS view.