Enterprise Manager Generic (MOSC)

MOSC Banner

Number of failed login attempts exceeds threshold value.

edited Jun 28, 2017 5:00AM in Enterprise Manager Generic (MOSC) 8 commentsAnswered

Hi Experts,

I am getting this OEM 13c alert "Number of failed login attempts exceeds threshold value." from Failed login count metric for only one of the database.

When I go to the database and run the below query I found so many failed logins attempts by sysman user just for a day.

select username,os_username,RETURNCODE,userhost,trunc(timestamp),count(*) failed_logins from dba_audit_trail where returncode<>

   0 and timestamp>trunc(sysdate) group by username,os_username,RETURNCODE,userhost,trunc(timestamp) order by 5;

USERNAME             OS_USERNAME          RETURNCODE      USERHOST                             TRUNC(TIMESTAMP)               FAILED_LOGINS
-------------------- -------------------- ---------- -------------------- ------------------------------ -------------

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center