龙空技术网

oracle 11g 修改sysman和dbsnmp用户密码后无法使用em

重庆思庄 470

前言:

如今大家对“修改oracle11g密码复杂”大概比较珍视,我们都想要剖析一些“修改oracle11g密码复杂”的相关资讯。那么小编也在网上收集了一些关于“修改oracle11g密码复杂””的相关文章,希望看官们能喜欢,小伙伴们一起来了解一下吧!

实验背景:

现有一台配置了EM的oracle数据库,数据库版本11.2.0.4,修改sysman和dbsnmp用户密码后重启em,发现em不可用。如图:

查看sysman和dbsnmp用户状态,发现sysman用户状态为锁住

正确修改sysman和dbsnmp用户密码的方法如下:

1、关闭em

[oracle@dbserver ~]$ emctl stop dbconsole

Oracle Enterprise Manager 11g DatabaseControl Release 11.2.0.4.0

Copyright (c) 1996, 2013 OracleCorporation. All rights reserved.

Stopping Oracle Enterprise Manager 11gDatabase Control ...

... Stopped.

[oracle@dbserver ~]$

2、修改sysman的密码并且给sysman用户解锁

3、执行emctl setpasswd dbconsole命令修改密码

[oracle@dbserver ~]$ emctl setpasswddbconsole

Oracle Enterprise Manager 11g DatabaseControl Release 11.2.0.4.0

Copyright (c) 1996, 2013 OracleCorporation. All rights reserved.

Please enter new repository password:

Repository password successfully updated.

[oracle@dbserver ~]$

4、修改dbsnmp用户的口令

[oracle@dbserver emd]$ pwd

/u01/app/oracle/product/11.2.0/db_1/dbserver_sztech1/sysman/emd

[oracle@dbserver emd]$

[oracle@dbserver emd]$ cp targets.xmltargets.xml.bak

[oracle@dbserver emd]$vi targets.xml

修改下面内容

<Property NAME="password"VALUE="oracle123" ENCRYPTED="FALSE"/>

5、重新启动em

[oracle@dbserver emd]$ emctl startdbconsole

Oracle Enterprise Manager 11g DatabaseControl Release 11.2.0.4.0

Copyright (c) 1996, 2013 OracleCorporation. All rights reserved.

Starting Oracle Enterprise Manager 11gDatabase Control ..... started.

------------------------------------------------------------------

Logs are generated in directory/u01/app/oracle/product/11.2.0/db_1/dbserver_sztech1/sysman/log

[oracle@dbserver emd]$

6、验证

可以看到,em可以正常使用

标签: #修改oracle11g密码复杂