ORA-28002 means that the password of the user will expire soon in N days, although the user is allowable to connect to the database. The error reminds you that to change the password in advance.
SQL> conn hr/hr@orclpdb
ORA-28002: the password will expire within 7 days
The database warned us that the password will expired in 7 days with ORA-28002. In fact, password expiration is controlled by password life time (PASSWORD_LIFE_TIME) in user's profile, the shorter lifetime, the sooner users see ORA-28002.
Solutions to ORA-28002
Theoretically, once the grace time is triggered, it has no way to return, but we have some ideas for you to think of.
There're several ways to solve ORA-28002.
- Change Password
- Defer Expiration
The formal way to solve it is to change the password.
An unofficial way to solve it is to revert the expiration.
As an user, you may change your password right away. To reuse the original password you forgot to set password, there will be more works to do.
Changing password for HR
Retype new password:
We can also use ALTER USER to change the password before expiration.
SQL> alter user hr identified by welcome1;
Where welcome1 is the explicit password, it's case-sensitive with or without double quotation marks.
For more ways to do it, you can also use various GUI tools to change the password.
For senior DBA, you may consider to defer user's password expiration.
Sometimes, the expiration notice might be very annoying to users, you may consider to totally avoid ORA-28002 password expiration notice.
2d solution is the BEST