Authentication failed ,if it persists check with system administrator

Issue: OEM login Authentication failed ,if it persists check with system administrator .

Root Cause : ERROR audit.AuditLogHandler auditLog.381 – Could not log the audit record java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition ORA-06512: at “SYSMAN.MGMT_AUDIT”, line 873 ORA-06512: at “SYSMAN.MGMT_AUDIT”, line 402 ORA-06512: at line 1 Log: $MIDDLEWARE_HOME/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc   Estive quebrando a cabeça com o erro acima, […

Solution:

SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;

0 rows updated.

SQL> commit;

Commit complete.

SQL>

SQL> conn SYSMAN

Enter password:

Connected.

SQL> exec mgmt_audit_admin.add_audit_partition;

PL/SQL procedure successfully completed.

SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;

0 rows updated.

SQL> commit;

Commit complete.

SQL> show parameter job_queue_processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     20
SQL> alter system set job_queue_processes=200 scope=both;

System altered.

SQL> show parameter job_queue_processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     200

SQL>exit

////////////////restart OMS////////////////////////////////////////////

[oracle@optimebs64 bin]$ ./emctl stop oms

Oracle Enterprise Manager Cloud Control 12c Release 3

Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

Stopping WebTier...

WebTier Successfully Stopped

Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

[oracle@optimebs64 bin]$ ./emctl start oms

Oracle Enterprise Manager Cloud Control 12c Release 3

Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

Starting Oracle Management Server...

Starting WebTier...

WebTier Successfully Started

Oracle Management Server Successfully Started

Oracle Management Server is Up

[oracle@optimebs64 bin]$

Now check URL  you will be able to login OEM page.... :)