// Oracle error reference

ORA-28001: the password has expired

The account's password reached the end of its PASSWORD_LIFE_TIME, so the user must change it before logging in again.

Error code
ORA-28001
Category
Connection and login
Error message
the password has expired

What it means

Oracle profiles can limit how long a password lasts (PASSWORD_LIFE_TIME, 180 days in the default profile of many releases). When it runs out, and any grace period has passed, logins fail with ORA-28001 until the password is changed. Interactive tools like SQL*Plus prompt for a new password; most applications just fail.

Common causes

  • The password is older than the profile allows, common for application and service accounts.
  • An administrator expired it with ALTER USER ... PASSWORD EXPIRE.

How to fix it

  1. Set a new password.

    ALTER USER app_user IDENTIFIED BY "N3w-Strong-Pass";
  2. For service accounts, assign a profile with a password life time that suits your rotation policy.

    CREATE PROFILE app_service LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    ALTER USER app_user PROFILE app_service;

Related errors

More connection and login errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

Work on Oracle in SQLly

A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.