Skip to Main Content
Forums

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!

Oracle user account is getting locked frequently

Tushar LapaniOct 8 2013 — edited Oct 9 2013

Hi everyone!!!

I am using Oracle 11g on Linux . I have user named "XXX" to whom I have assigned a DEFAULT profile. The Password parameters in DEFAULT profile are as follow.

Resource Name                                      Resource                                 Limit

FAILED_LOGIN_ATTEMPTS                    PASSWORD                            20

PASSWORD_LIFE_TIME                        PASSWORD                            UNLIMITED

PASSWORD_LOCK_TIME                      PASSWORD                           UNLIMITED

PASSWORD_REUSE_TIME                   PASSWORD                            UNLIMITED

PASSWORD_REUSE_MAX                   PASSWORD                             UNLIMITED

I don't know why my user is getting locked continuously. Even i haven't reached Failed_login_attempts (20). Each time I require to unlock user account as SYS user and then I can connect as XXX user.

And another thing that I want to know is when user account's status is set to LOCKED, EXPIRED, EXPIRED & LOCKED and LOCKED(TIME).

Thanks & Regards

Tushar Lapani
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Oct 8 2013
#general-database-discussions
15 comments
19,681 views