重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 登录EM 12C，提示"验证失败"的BUG及解决办法 [打印本页]

作者: meijie0423 时间: 2020-2-26 21:12
标题: 登录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: <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

作者: 郑全 时间: 2020-2-29 22:31
好的，又一个解决办法

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)