em – grepOra

EM Event: Number of failed login attempts exceeds threshold value [Part 1]

By matheusdba 15 de March de 2017 15 de March de 2017

Hello!
Just got this error? Very simple to check. Below the easy solution using audit:

Activating audit to failed logins:

SQL> audit session whenever not successful;

Audit succeeded.

Then wait some time and check:

More“EM Event: Number of failed login attempts exceeds threshold value [Part 1]”

Database, Enterprise Manager, Errors and Bugs

EM Repository: ORA-00060: Deadlock detected error in alert log

By matheusdba 1 de March de 2017 19 de March de 2017

Hello!
Some time ago I found some ORA-00060: Deadlock detected. errors in a client OEM database… Like this:

Thu Dec 22 09:01:55 2016
ORA-00060: Deadlock detected. More info in file /oracle/oemdb/diag/rdbms/oemdb/oemdb/trace/oemdb_ora_1757.trc.
Thu Dec 22 09:02:07 2016
ORA-00060: Deadlock detected. More info in file /oracle/oemdb/diag/rdbms/oemdb/oemdb/trace/oemdb_ora_1759.trc.
ORA-00060: Deadlock detected. More info in file /oracle/oemdb/diag/rdbms/oemdb/oemdb/trace/oemdb_ora_1759.trc.

In summary, after investigating the trace (as per below), found that the issueis caused by the following command:

More“EM Repository: ORA-00060: Deadlock detected error in alert log”