10g中，登录管理中心，显示“数据库状态当前不可用“

LoveWinter

http://blog.itpub.net/post/493/15071
问题的原因出在EM有自己的配置文件,光是修改了数据库
级别的口令是不够的. 你需要手工调整或者使用emctl.

NinGoo

有没有配置监听？

我也遇到过这个问题，后来配置监听后正常

orchidllh

谢谢 我的问题已经解决了，是通过emca -r重新配置了资料库就ok了

badboy056

命令框下输入cmd--emca，按照提示一步步操作就OK。
做这些之前要确保环境变量是要改变的数据库，比如，我的电脑上装了server端和client端，我想改变的数据库当然是server端上的，这时候我就要将系统变量path设置为e:\Oracle\product\10.1.0\db_1\bin;

macrossplus

配置并启用dbsnmp用户

zengxian1

我的服务器也遇到了类似的问题。
我的sysman的用户口令曾经修改过，现在每次
emctl start dbconsole
的时候都会锁定该用户，我手工将其解锁，但重启服务仍会锁定。

以下是我重启服务的日志文件：
[oracle@bj log]$ tail emagent.trc
2005-03-17 15:14:51 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:15:20 Thread-76749744 ERROR upload: Error in uploadXMLFiles.  Trying again in 123.00 seconds.
2005-03-17 15:15:21 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:15:21 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:15:22 Thread-41372592 ERROR command: nmejcn: received no status header from repository at http://bj:5500/em/upload/
2005-03-17 15:15:51 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:15:51 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:16:21 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:16:21 Thread-76749744 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2005-03-17 15:16:26 Thread-41372592 ERROR command: nmejcn: received no status header from repository at http://bj:5500/em/upload/

[oracle@bj log]$ tail emoms.log

2005-03-17 15:16:51,702 [HttpRequestHandler-12617107] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-28000: the account is locked

2005-03-17 15:16:51,703 [HttpRequestHandler-12617107] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://bj:1830/emd/main)(ERROR = INTERNAL_ERROR)
2005-03-17 15:17:12,274 [OMSHeartbeatThread] ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

2005-03-17 15:17:12,332 [NotificationMgrThread] ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

2005-03-17 15:17:12,543 [XMLLoader0] ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

[oracle@bj log]$ tail emoms.trc
2005-03-17 15:17:21,753 [HttpRequestHandler-6923467] ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

2005-03-17 15:17:21,787 [HttpRequestHandler-6923467] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-28000: the account is locked

2005-03-17 15:17:21,788 [HttpRequestHandler-6923467] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://bj:1830/emd/main)(ERROR = INTERNAL_ERROR)
2005-03-17 15:17:21,824 [HttpRequestHandler-19608393] ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked

2005-03-17 15:17:21,859 [HttpRequestHandler-19608393] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-28000: the account is locked

2005-03-17 15:17:21,861 [HttpRequestHandler-19608393] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://bj:1830/emd/main)(ERROR = INTERNAL_ERROR)
[oracle@bj log]$ tail emagent.log
2005-03-17 14:52:05 Thread-3076427904 EMAgent started successfully (00702)
2005-03-17 15:03:13 Thread-3076427904 EMAgent normal shutdown (00703)
2005-03-17 15:05:01 Thread-3076415616 Starting Agent 10.1.0.3.0 from /home/oracle/product/10.1.0/db_1 (00701)
2005-03-17 15:05:02 Thread-3076415616 EMAgent started successfully (00702)
2005-03-17 15:06:50 Thread-3076415616 EMAgent normal shutdown (00703)
2005-03-17 15:08:32 Thread-3076427904 Starting Agent 10.1.0.3.0 from /home/oracle/product/10.1.0/db_1 (00701)
2005-03-17 15:08:32 Thread-3076427904 EMAgent started successfully (00702)
2005-03-17 15:12:35 Thread-3076427904 EMAgent normal shutdown (00703)
2005-03-17 15:14:19 Thread-3076427904 Starting Agent 10.1.0.3.0 from /home/oracle/product/10.1.0/db_1 (00701)
2005-03-17 15:14:20 Thread-3076427904 EMAgent started successfully (00702)
[oracle@bj log]$ tail emdctl.trc
2005-03-17 15:13:51 Thread-3076419712 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:13:54 Thread-3076436096 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:13:56 Thread-3076432000 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:13:59 Thread-3076427904 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:02 Thread-3076440192 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:05 Thread-3076415616 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:08 Thread-3076427904 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:11 Thread-3076436096 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:14 Thread-3076423808 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)
2005-03-17 15:14:17 Thread-3076419712 WARN  http: snmehl_connect: connect failed to (bj:1830): Connection refused (error = 111)

看起来就像是账号被锁定的问题，但是不知道如何解决呢，我手工解锁后不对，重启服务账号又锁定了。



www.meinv17.com

kw002007

多谢，学到了好多知识

def3ok2

可能是因为数据库的状态为装载或不装载