oracle 11g Enterprise Manager配置失败

Question

Oracle11g EM配置失败了
尝试过关闭防火墙，也试过在 Net Manager 添加监听程序并在Database configuration Assistant重新配置，但结果都不理想，希望大神们能搭一把手

enConfig.log 日志 报错如下

---

2018-9-2 21:01:44 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: ORA-28000: the account is locked

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
    at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
    at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1066)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)

2018-9-2 21:06:39 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
配置: 将配置数据上载到资料档案库时出错
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

    at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
    at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
2018-9-2 21:06:39 oracle.sysman.emcp.EMReposConfig invoke
信息: 有关详细资料, 请参阅 C:\app\cfgtoollogs\emca\orcl\emca_repos_config_<日期>.log 中的日志文件。
2018-9-2 21:06:39 oracle.sysman.emcp.EMReposConfig invoke
严重: 将配置数据上载到资料档案库时出错
2018-9-2 21:06:39 oracle.sysman.emcp.EMConfig perform
严重: 将配置数据上载到资料档案库时出错
有关详细资料, 请参阅 C:\app\cfgtoollogs\dbca\orcl\emConfig.log 中的日志文件。
2018-9-2 21:06:39 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace: 
oracle.sysman.emcp.exception.EMConfigException: 将配置数据上载到资料档案库时出错
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:397)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
2018-9-2 21:06:39 oracle.sysman.emcp.EMConfig restoreOuiLoc
配置: Restoring oracle.installer.oui_loc to C:\app\product\11.2.0\dbhome_1\oui

Answer 1

参考这篇文章：https://blog.csdn.net/shipeng...

解锁SYSMAN、DBSNMP
或
更改配置文件/u01/app/oracle/11.2.0/db_1/sysman/emd/targets.xml，将上面两个用户的密码更新到配置文件中