Re: oracle account suddenly change to lock???
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "knecht.stefan@xxxxxxxxx" <knecht.stefan@xxxxxxxxx>
- Date: Sat, 21 Nov 2009 11:55:45 -0500
Also, after you modify the profile appropriately, you'll still have to
explicitly unlock the accounts that are already locked.
Alter user your_user account unlock;
HTH,
-Mark
Sent from my iPhone
On Nov 21, 2009, at 11:42 AM, "Stefan Knecht"
<knecht.stefan@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>> wrote:
That would be alter profile default limit failed_login_attempts unlimited;
I'm assuming it's the DEFAULT profile, otherwise check dba_profiles for the
name.
The SQL reference also has the complete syntax, BTW.
Cheers
Stefan
=========================
Stefan P Knecht
CEO & Founder
<mailto:s@xxxxxxxx>s@xxxxxxxx<mailto:s@xxxxxxxx>
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
<mailto:info@xxxxxxxx>info@xxxxxxxx<mailto:info@xxxxxxxx>
<http://www.10046.ch>http://www.10046.ch
=========================
On Sat, Nov 21, 2009 at 5:13 PM, dba1 mcc
<<mailto:mccdba1@xxxxxxxxx>mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>> wrote:
Thank you for answer. my profile set "FAILED_LOGIN_ATTEMPTS =10".
how to change it to large?
Thanks.
--- On Sat, 11/21/09, Stefan Knecht
<<mailto:knecht.stefan@xxxxxxxxx>knecht.stefan@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>>
wrote:
> From: Stefan Knecht
> <<mailto:knecht.stefan@xxxxxxxxx>knecht.stefan@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>>
> Subject: Re: oracle account suddenly change to lock???
> To: <mailto:mccdba1@xxxxxxxxx> mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>
> Cc: "oracle-l-freelists"
> <<mailto:oracle-l@xxxxxxxxxxxxx>oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
> Date: Saturday, November 21, 2009, 11:08 AM
> Hi
>
> 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
> <mailto:s@xxxxxxxx> s@xxxxxxxx<mailto:s@xxxxxxxx>
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
>
>
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> <mailto:info@xxxxxxxx> info@xxxxxxxx<mailto:info@xxxxxxxx>
> <http://www.10046.ch> http://www.10046.ch
>
> =========================
>
>
>
>
>
> On Sat, Nov 21, 2009 at 4:48 PM,
> dba1 mcc
> <<mailto:mccdba1@xxxxxxxxx>mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>>
> 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.
>
>
>
>
>
>
>
>
>
> --
>
> <//www.freelists.org/webpage/oracle-l>
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
>
>
Other related posts:
