How to Unexpire Password
To solve ORA-28001 and ORA-28002, the best way is to follow the rule to change user's password. However, if you had to continue using the… Read More »How to Unexpire Password
PASSWORD_LIFE_TIME
How to Resolve ORA-28002: the password will expire within 7 days
ORA-28002 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.… Read More »How to Resolve ORA-28002: the password will expire within 7 days
How to Resolve ORA-28001: the password has expired
ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »How to Resolve ORA-28001: the password has expired
How to Set Password Never Expire
PASSWORD_LIFE_TIME UNLIMITED The password expiration notice is actually an Oracle error, ORA-28002: the password will expire within days. To avoid the error, we have to… Read More »How to Set Password Never Expire