oem登录报错

sysman登录oem页面报错如下：

查看oms状态：

cd <OMS_HOME>/bin emctl status oms -details

2022-09-14 09:22:23,886 [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR audit.AuditManager auditLog.362 - Could not Log audit data, Error:java.sql.SQLException: ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","SYS_IL0000094750C00023$$","pacdHds_kkpaco","kksgaAlloc: firstN") ORA-06512: at "SYSMAN.MGMT_AUDIT", line 492 ORA-06512: at "SYSMAN.MGMT_AUDIT", line 406 ORA-06512: at line 1

2022-09-14 09:22:47,105 [#EM_SYSTEM_POOL#:ConsolePerfStatsAggregator] ERROR console.ConsolePerfCollector logp.251 - Error in parsing maxInactiveTime value null 2022-09-14 09:23:47,109 [#EM_SYSTEM_POOL#:ConsolePerfStatsAggregator] ERROR console.ConsolePerfCollector logp.251 - Error in parsing maxInactiveTime value null 2022-09-14 09:23:55,912 [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR da.EmMosPatchRecommendationDaoBean logp.251 - PATCH getPatchRollupCounts: Internal Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

查看oms状态详细显示用户名密码不识别。

bug造成，修复：

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

SQL> exec mgmt_audit_admin.add_audit_partition;

SQL> commit ;

如果当前SYSMAN密码不知道，修改密码：

Stop all the OMS: cd <OMS_HOME>/bin emctl stop oms Modify the SYSMAN password: cd <OMS_HOME>/bin emctl config oms -change_repos_pwd

If the current SYSMAN password is unknown cd $OMS_HOME/bin emctl stop oms [oracle@hzem12c01 bin]$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd "oracle" -new_pwd "oracle123" 第一个为sys的密码，第二个为修改sysman的密码

emctl stop oms -all emctl start oms

参考文档：

How to Modify the Password for SYSMAN and related Users in the Enterprise Manager Cloud Control (Doc ID 1365930.1)

EM 12c, EM 13c: Login to Enterprise Manager Cloud Control with the Correct Password Fails with Error: Authentication failed. If problem persists, contact your system administrator (Doc ID 1493151.1)