Friday, March 29, 2013

ORA-28002: the password will expire within 7 days

Few days back I came across an oracle error ORA-28002 while login into database through sqlplus.
I simulate it over my test machine with user 'SCOTT'.








I performed the following troubleshooting.


































Though I have alter the profile "Default" attribute "Password_limit_time" to "unlimited" but still I'm getting the same ORA-28002 message.

So to fix this you need to change the user password by the current one.













No comments:

Post a Comment