EM 12C –密码验证失败的Bug及解决方案

时间:2022-06-30 21:38:42
EM 12C – Authentication failed. If problem persists, contact your system administrator
 janeiro 28th, 2014  dbopenadmin
2014-01-28 16:36:48,068 [[ACTIVE] ExecuteThread: ’0′ for queue: ‘weblogic.kernel.Default (self-tuning)’] ERROR audit.AuditLogHandler auditLog.381 – 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 873
ORA-06512: at “SYSMAN.MGMT_AUDIT”, line 402
ORA-06512: at line 1


Log: $MIDDLEWARE_HOME/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc


 


Estive quebrando a cabeça com o erro acima, resolvi da seguinte forma:


Conecte no console do Banco do EM com o usuário SYSMAN


SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;
SQL> exec mgmt_audit_admin.add_audit_partition;
SQL> commit ;


Pare e suba o serviço:


./emctl stop oms -all
./emctl start oms


Neste ponto a conexão com o EM 12C deve estar OK.


Mais informações, check o MOS, artigo: 1493151.1


 Posted in Enterprise Manager Cloud Control 12c
« SQL e o que é DML, DDL, DCL, DTL e DQL Both comments and pings are currently closed.
Comments are closed.