ORA-28001: the password has expired

Hi,

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

Details of error are as follows.

ORA-28001: the password has expired

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>

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/