ORA-28001: The password has expired

I share solution next error:




Steps:

1. First connect from SQL Developer or SQL PLUS. Use the user SYSTEM or SYSDBA

2. SQL> connect / as SYSDBA

3. Run next query:

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

4. Find your User and Check account_status

5. And the last. alter the table with next query

ALTER USER your_user IDENTIFIED BY your_new_or_same_password account unlock;

That is it.