ORA-28001: the password has expired

ORA-28001: the password has expired

Passwords in Oracle can expire after some time. Here is solution how to remove expiration and create new password.

1. Open sqlplus
2. Enter connect / as sysdba
3. Find profile connected to expired user:  select profile from DBA_USERS where username='';
4. Default name of profile is DEFAULT.
5. alter profile DEFAULT limit password_life_time UNLIMITED;
6. To show more info: select resource_name,limit from DBA_PROFILES;
7. Change user's password: alter user identified by ;
8. Commit

Now you can connect again ;)