Wednesday, November 8, 2017

EM12c : Authentication Failure while login to GUI console with the Correct Password

I was trying to login to OEM GUI console and was getting the below error, I was pretty sure that my password was correct and even tried with different user account but every time it was failing with “Authentication failed. If problem persists, contact your system administrator”

I checked the emoms.trc logs which had the below errors

omsserver1:/opt/oracle/gc_inst12cR5/em/EMGC_OMS1/sysman/log:(oracle)$ view emoms.trc

Error:
2017-11-07 21:52:31,166 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR audit.AuditLogHandler auditLog.378 - 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 919
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 417
ORA-06512: at line 1

2017-11-07 21:52:31,168 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR authz.EMSecurityContext doEMLogout.522 - SQLException caught while destroying auditSessionGuid 5D6C463204EBB157E053B71ED00A7F0F
2017-11-07 22:01:37,537 [[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN  auth.EMRepLoginFilter doFilter.458 - InvalidEMUserException caught in EMRepLoginFilter: Failed to login using repository authentication for user: JOBADM

Solution:
Verified that the job_queue_processes are not set to zero and then executed the below command to add the audit partitions. Verified that I am able to login to console post that.

SQL> alter session  set current_schema=sysman;
Session altered.

SQL> exec mgmt_audit_admin.add_audit_partition;

PL/SQL procedure successfully completed.