Search notes:

ORA-28001: the password has expired

select
   username,
   expiry_date,
   password_change_date,
   last_login
from
   dba_users
where
   account_status = 'EXPIRED';

Changing password in SQL*Plus

An expired password can be changed with SQL*Plus: this tool will ask for a new password when it receives an ORA-28001.

$ development/databases/Oracle/SQL-Plus[sqlplus] rene/…@ora19
…
ERROR:
ORA-28001: the password has expired


Changing password for rene
New password: …
Retype new password: …
Password changed
…

Changing a password with ALTER USER privileges

A user having the alter user system privilege can change a user's password:

alter user rene identified by theNewSecretPassword;

ORA-28001: the password has expired

Changing password in SQL*Plus

Changing a password with ALTER USER privileges

See also