[重庆思庄每日技术分享]-登录EM 12C，提示“验证失败“的BUG及解决办法

问题：

日志：/u01/app/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/sysman/log/emoms.trc

注意：不同环境的emoms.trc路径有所不同。

[2020-02-26T20:25:48.266+08:00] [EMGC_OMS1] [ERROR] [] [oracle.sysman.core.gccompliance.jobs.ComplianceScoreHistory] [tid: Job Step 31436 Job Long-System Pool:JobWorker] [userId: ] [ecid: 0000N21SmSxEWNYFLrFS8A1ULaCP000002,1:18368] [APP: empbs] java.sql.SQLException:

ORA-14400: inserted partition key does not map to any partition[[

ORA-06512: at "SYSMAN.EM_COMPLIANCE_HIST", line 8

ORA-06512: at line 1

解决方案：

Connect SysMan, check the value of "prepopulate_days" before updating, and recover if it fails.

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

SQL>exec mgmt_audit_admin.add_audit_partition;

SQL>commit;

Under the /OMS_HOME/bin, execute:

./emctl stop oms -all

./emctl start oms