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.
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
Post a Comment