ORA-28001: The password has expired



---ORA-28001: The password has expired

1.Connect as sysdba to the database. C:\Users\Siry>sqlplus / as sysdba

2.Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

3.Set a password for the locked user. SQL> ALTER USER user_name IDENTIFIED BY password;
User altered.

4.Unlock the user account. SQL> ALTER USER user_name ACCOUNT UNLOCK;
User altered.

5.Make sure your user is not locked anymore. SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;