ORA-28001: The password has expired

Oracle ORA-28001

Solution

  • Connect as sysdba:
sqlplus / as sysdba
  • Set password’s life time to unlimited:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
  • Set new password for the locked user:
ALTER USER user_name IDENTIFIED BY password;
  • Unlock user:
ALTER USER user_name ACCOUNT UNLOCK;
  • Make sure user not locked any more:
SELECT USERNAME, ACCOUNT_STATUS FROM DBA_USERS;

Reference: ORA-28001: The password has expired
Reference: Stackoverflow