Hi, I'm a newbie oracle dba and I just get complain from user that his account is locked. When I checked using Toad for Oracle, the user status is Locked (Timed). The failed_login_attempts is currently set to unlimited. Can anyone tell me why the user status is Locked (Timed). thanks
That would be strange. Normally "Locked (timed)" would occur after exceeding n Failed_Logins causing Oracle to lock the account.
Are you sure that you've checked the correct profile for the user ? FAILED_LOGIN_ATTEMPTS is defined as a Profile attribute and a database can have multiple profiles, with different sets of users allocated different profile.
Also you need to confirm that FAILED_LOGIN_ATTEMPTS was not recently modified.
Hemant K Chitale