ORA-28002 Oracle Password will Expire in 7 days

Today, When I reached office, I got a message while login to database "ORA-28002 Oracle Password will expire in 7 days". I followed these steps

1. Logon to the product database as the SYSTEM or SYS user
2. Find the profile that has the PASSWORD_LIFE_TIME set

select * from dba_profiles where RESOURCE_NAME LIKE 'PASSWORD_LIFE_TIME';

3. Alter the profiles with the following statement:

ALTER PROFILE profile_name LIMIT PASSWORD_LIFE_TIME UNLIMITED;

After that you will get information like "Account Password will expire soon".
To avoid this run these commands in sequence.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_GRACE_TIME 0;

Then change the password of user.

Comments