ITPub博客

首页 > 数据库 > Oracle > oem登录报错

oem登录报错

原创 Oracle 作者:lmxx2020 时间:2024-01-23 18:02:37 0 删除 编辑

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密码不知道,修改密码:

  1. Stop all the OMS: cd <OMS_HOME>/bin emctl stop oms
  2. 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) 


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22967847/viewspace-3004859/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2024-01-09

  • 博文量
    106
  • 访问量
    90383