Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User account not unlocking after password_lock_time

oraLaroSep 13 2019 — edited Sep 30 2019

12.1.0.2

This had worked some time in the past for us, not sure when it stopped.

create user test identified by 123;

grant connect to test;

select * from dba_profiles where profile = 'DEFAULT';

FAILED_LOGIN_ATTEMPTS = 5;

PASSWORD_LOCK_TIME=.0006    -- a minute

login with bad password 5 times, account locks

select account_status, lock_date, profile from dba_users where username = 'TEST';

LOCKED(TIMED) 13/09/2019 10:49:06    DEFAULT

several minutes later still not unlocked and the user that raised this has his LOCKED(TIMED) for a couple of days now since it was locked.  DEFAULT profile as well.

Is there something else I can check? 

This post has been answered by Adityanath Dewoolkar on Sep 13 2019
Jump to Answer
Comments
Post Details
Added on Sep 13 2019
7 comments
1,871 views