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

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

Added on Sep 13 2019

#general-database-discussions

7 comments

1,879 views