我是真的跟随这篇文章解决了我EM12C不能登录的问题。不是随便乱找一篇文章翻译的。

解决Oracle12c Cloud Control登录验证出错问题

前几天我试图登录我的EM12c R4环境与SSA_ADMINISTRATOR用户，我得到了以下错误 :

Authentication failed. If problem persists, contact your system administrator.

我很确定我的密码是正确的，所以我试了下SYSMAN用户————仍然有同样的错误。为了确认我有正确的密码，我用SYSMAN用户试图登录到存储库数据库，是成功的，所以我知道，奇怪的错误发生了。

SQL> connect sysman/
Enter password:
Connected.

因此，我转到…/em/EMGC_OMS1/sysman/log/emams.log，看到以下错误

2015-05-18 21:22:06,103 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR audit.AuditManager auditLog.368 - Could not Log audit data, Error:java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 492
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 406
ORA-06512: at line 1

Which led me to believe that the JOB_QUEUE_PROCESSES was set to 0, but it wasn’t the case, it was set to 50, but it is actually not a correct limit, so I bumped it up to 1000 as per documentation and tried to rerun the EM12c repository DBMS Scheduler jobs as per the documentation in 1498456.1
导致我相信是JOB_QUEUE_PROCESSES的问题的原因是它被设置成了0.但不是这个问题，因为我把它设置成了50.但是50依然不是一个正确的值。所以我又根据文档把它提升到1000，然后根据文档1498456.1尝试重新运行EM12C的调度job

SQL> show parameter JOB_QUEUE_PROCESSES
 
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 50
SQL> alter system set JOB_QUEUE_PROCESSES=1000 scope = both;
 
System altered.
 
SQL> show parameter both
SQL> show parameter job
 
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 1000
SQL> connect / as sysdba
Connected.
SQL> alter system set job_queue_processes = 0;
 
System altered.
 
SQL> connect sysman/
Connected.
SQL> exec emd_maintenance.remove_em_dbms_jobs;
 
PL/SQL procedure successfully completed.
 
SQL> exec gc_interval_partition_mgr.partition_maintenance;
 
PL/SQL procedure successfully completed.
 
SQL> @$OMS_HOME/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN
old 11: AND owner = upper('&RECOMPILE_REPOS_USER')
new 11: AND owner = upper('SYSMAN')
old 26: dbms_utility.compile_schema(upper('&RECOMPILE_REPOS_USER'),FALSE);
new 26: dbms_utility.compile_schema(upper('SYSMAN'),FALSE);
old 41: WHERE owner = upper('&RECOMPILE_REPOS_USER')
new 41: WHERE owner = upper('SYSMAN')
old 84: AND owner = upper('&RECOMPILE_REPOS_USER')
new 84: AND owner = upper('SYSMAN')
old 104: AND ds.table_owner = upper('&RECOMPILE_REPOS_USER')
new 104: AND ds.table_owner = upper('SYSMAN')
 
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
 
SQL> connect / as sysdba
Connected.
SQL> alter system set job_queue_processes = 1000;
 
System altered.
 
SQL> connect sysman/
Enter password:
Connected.
SQL> exec emd_maintenance.submit_em_dbms_jobs;
 
PL/SQL procedure successfully completed.
 
SQL> commit;
 
Commit complete.

后来，我启动了OMS。但即使我修复了调度工作任务的错误，仍然有相同的报错。当时我在emoms.log中看到了如下的错误：

2015-05-18 22:29:09,573 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN auth.EMRepLoginFilter doFilter.450 - InvalidEMUserException caught in EMRepLoginFilter: Failed to login using repository authentication for user: SSA_ADMIN
oracle.sysman.emSDK.sec.auth.InvalidEMUserException: Failed to login using repository authentication for user: SSA_ADMIN

因此我按照文档1493151.1所述，做了对SYSMAN.MGMT_AUDIT_MASTER表的更新，然后跑了MGMT_AUDIT_ADMIN.ADD_AUDIT_PARTITION存储过程

oracle $ sqlplus
 
Enter user-name: sysman
Enter password:
 
SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;
 
1 rows updated. (这里我实践的时候是0)
 
SQL> select count(1) from mgmt_audit_master where prepopulate_days is null;
 
COUNT(1)
----------
0
 
SQL> exec mgmt_audit_admin.add_audit_partition;
 
PL/SQL procedure successfully completed.
 
SQL> commit;
 
Commit complete.

当我做了以上动作之后，我可以用所有的admin权限账户正确登录我的EM12C。

结论就是

即使没有将JOB_QUEUE_PROCESSES设置为0，这也是它失败的原因，因为它是该参数的一个比较低的值，所以小心设置这个参数，得确保遵从最新的安装指南。