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密码不知道,修改密码:
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)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22967847/viewspace-3004859/ ,如需转载,请注明出处,否则将追究法律责任。