Re: oracle account suddenly change to lock???

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

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

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?
>
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l