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