检查em集群配置报错：ORA-28000

最新推荐文章于 2021-08-13 04:55:22 发布

DBGuardian

最新推荐文章于 2021-08-13 04:55:22 发布

阅读量2.2k

点赞数

分类专栏： oracle性能优化 RAC RAC EM配置

本文链接：https://blog.csdn.net/shipeng1022/article/details/50242905

版权

oracle性能优化同时被 3 个专栏收录

55 篇文章 0 订阅

订阅专栏

RAC

20 篇文章 0 订阅

订阅专栏

RAC EM配置

5 篇文章 0 订阅

订阅专栏

报错日志如下：

Aug 25, 2015 6:12:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: Waiting for 5 second before reconnection
Aug 25, 2015 6:12:24 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine connecting with Service Name: rac, oracleHome: /u01/app/oracle/11.2.0/db_1, and user: DBSNMP host: rac2 port: 1521
Aug 25, 2015 6:12:24 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: 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:1650)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:973)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:912)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineRemotely(GeneralUtil.java:593)
at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:642)

解决办法：

1 查询发现SYSMAN、DBSNMP并没有锁定

2 到目录下/u01/app/oracle/11.2.0/db_1/sysman/emd/targets.xml,修改此文件：

<?xml version = "1.0"?>
<Targets>
<Property NAME="DBSNMP" VALUE="E066D214D5421CCC" ENCRYPTED="TRUE"/>
<Property NAME="SYSMAN" VALUE="447B729161192C24" ENCRYPTED="TRUE"/>
</Targets>

其中密码可以通过视图select name,password from user$ 查询。修改后一起OK！