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
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
-
Set a new password.
ALTER USER app_user IDENTIFIED BY "N3w-Strong-Pass";
-
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
ORA-28000the account is lockedORA-01017invalid username/password; logon denied18487SQL Server: Login failed, password expired
More connection and login errors
ORA-12154TNS: could not resolve the connect identifierORA-12514TNS: listener doesn't know the requested serviceORA-12505TNS: listener doesn't know the SIDORA-12541TNS: no listenerORA-12170TNS: connect timeout occurredORA-03113end-of-file on communication channelORA-03135connection lost contactORA-01034ORACLE not available
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
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.