ORA-28001: the password has expired

Mehmet Salih Deveci

4 years ago

Hi,

Sometimes You can get ” ORA-28001: the password has expired ” error.

Details of error are as follows.

ORA-28001: the password has expired

Cause: The user’s account has expired and the password needs to be changed

Action: change the password or contact the DBA

Check the users which users are expired.

SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';

You can solve this error by using its existing password or with new password as follows.

ALTER USER USERNAME IDENTIFIED BY PASSWORD;



SQL> ALTER USER MEHMET IDENTIFIED BY DEVECI;         
User altered.

Or you can unlock it as follows, then change default profile PASSWORD_LIFE_TIME to UNLIMITED as follows.

SQL> ALTER USER system ACCOUNT UNLOCK;
User altered.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

SQL>