Never mind... I found out that there was a user process that was trying to
connect repeatedly to the user account DB1, with a different password. By
the time I unlocked the account and went back to check the status of the
account, it would fail 10 times and lock the account again, giving me the
impression that the 'ACCOUNT UNLOCK' was not working... Sorry for the
bother.... Thanks! Rajesh
"Rajesh Kapur" <rkapur_at_mpr.org> wrote in message
news:11kpvjki4tugh81_at_corp.supernews.com...
> Oracle 10g v2 on Linux...
> I have a user account that shows locked(timed) on windows manager. I am
> connected with sys as sysdba. When I try to unlock the account, the EM
> issues the command ALTER USER "DB1" ACCOUNT UNLOCK. However, the account
> does not unlock. I used a create like command to create a user DB2 like
> DB1. DB2 showed unlocked, as expected. then I dropped user DB1 and
> recreated it like DB2. The user DB1 continues to show LOCKED(TIMED) even
> after drop/recreate.
>
> How can I unlock a locked(timed) user account?
> Thanks!!!
>
Received on Wed Oct 12 2005 - 09:55:43 CDT
