Re: oracle account suddenly change to lock???
Date: Sat, 21 Nov 2009 17:08:25 +0100
Check dba_profiles for any limits that may cause an account to be locked -- namely failed_login_attempts (would results in account being LOCKED after too many bad attempts), or password_life_time (would result in it becoming EXPIRED). Cheers
Stefan P Knecht
CEO & Founder
10046 Consulting GmbH
Cell +41 (0) 79 571 36 27
On Sat, Nov 21, 2009 at 4:48 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> we have ORACLE 10GR2 on Linux server. More of account on our database will
> sudden change to "lock".
> I check DB parameter "resource_limit" and it set to "false".
> any ideal?