登录EM 12C，提示"验证失败"的BUG及解决办法

meijie0423

问题之一：
日志：/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: <anonymous>] [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

郑全

好的 ，又一个解决办法