Re: account locking up

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Thu, 11 Apr 2013 11:04:35 +0100
Message-ID: <CAPMSPxO=7xKJ5tRcuiRitVPaUCLsQ94+06bQmkScQbE5nO2vRQ_at_mail.gmail.com>

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

On 11 April 2013 08:32, Howard Latham <howard.latham_at_gmail.com> wrote:

> You could try enterprise manager and its agents. It retrys frequently.
>
> Sent from my Windows Phone
> From: C P
> Sent: 11/04/2013 05:55
> To: oracle-l_at_freelists.org
> Subject: account locking up
> All,
> We recently migrated an application into a 11g database in a server. After
> the upgrade one of the accounts necessary for connecting to the DB keeps
> locking up, because some application is trying to log in with wrong
> password. Our application team is unable to come up with a full list of
> servers or locations where the connections could come from. I was trying to
> find the information from the listener log. It has few entries close
> (within a minute or two) the time of lock issues, but the status code is
> '0' which I think indicates a success. I am assuming it is not a failed
> connection. Is there a way in which to figure out where the connections are
> coming from. TIA
>
> CP.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards

Pete


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

Received on Thu Apr 11 2013 - 12:04:35 CEST