RE: account locking up

  • From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 11 Apr 2013 09:03:16 -0700

Be careful here.  There is a new feature in Oracle 11 concerning failed logins. 
 MOS is not responding right now but

http://askdba.org/weblog/2012/01/11g-multiple-failed-login-attempt-can-block-new-application-connections/

explains it adequately.    It can be a real pain.   There is a patch to turn 
off the behavior.

I think the number is 13696216, but I cannot verify that now.


Ian A. MacGregor
SLAC National Accelerator Laboratory
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Peter Hitchman [pjhoraclel@xxxxxxxxx]
Sent: Thursday, April 11, 2013 3:04 AM
To: oracle-l
Subject: Re: account locking up

Hi
You could also change the profile being used to allow unlimited
failed_login_attempts, to stop what is in effect a denial of service
situation.
Regards
Pete


ç\--
//www.freelists.org/webpage/oracle-l


Other related posts: