sysman 账号 oracle em console的一些问题
前几天用下面的命令修改了 sysman的密码。
[oracle@racnode1 ~]$ emctl setpasswd dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://racnode1:1158/em/console/aboutApplication Please enter new repository password: Repository password successfully updated. [oracle@racnode1 ~]$
然后登陆EM就出问题了,首先是登陆的时候让输入的是OS的账号密码而不是oracle的账号,其次是登陆进去之后有这么一段话,也就是说EM认为Oracle DB 现在没启动。
The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation.
这种情况是因为修改了sysman密码的原因。 sysman 和 dbsnmp这两个用户的密码不可以随便改。因为他们在db中存了一份儿在EM中还有,所以要改就要一起修改。 下面解决这个问题的步骤是
1. 在db中解锁sysman这个用户 修改密码。
SQL> alter user sysman account unlock; User altered. SQL> alter user sysman identified by passw0rd; User altered.
2. 修改em中sysman的密码。 这个过程包括三小步骤
停止em
[oracle@racnode1 ~]$ emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://racnode1:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ... ... Stopped.
修改密码
[oracle@racnode1 ~]$ emctl setpasswd dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://racnode1:1158/em/console/aboutApplication Please enter new repository password: Repository password successfully updated.
启动em
[oracle@racnode1 ~]$ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://racnode1:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control ........... started. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/racnode1_orcl/sysman/log
然后登陆em 刷新一下就好了