故障描述
http://192.168.1.45:1158/em //无法访问
登陆数据训服务器查看database control状态
bash-3.00$ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory /export/home/oracle/orcl/product/10gr2/tnms_TNMS/sysman/log
bash-3.00$ cd /export/home/oracle/orcl/product/10gr2/tnms_TNMS/sysman/log
bash-3.00$ ls
emagent.log emagentfetchlet.log emdb.nohup emdctl.log emoms.log nmcTNMS1521
emagent.trc emagentfetchlet.trc emdb.nohup.lr emdctl.trc emoms.trc
bash-3.00$ ls -ltr
总数 26468
-rw-r----- 1 oracle oinstall 0 5月 29日 22:58 emdctl.log
-rw-r----- 1 oracle oinstall 2217 5月 29日 22:59 emdb.nohup.lr
-rw-r----- 1 oracle oinstall 157 5月 29日 23:00 emagent.log
-rw-r----- 1 oracle oinstall 180 5月 29日 23:00 emagentfetchlet.log
-rw-r----- 1 oracle oinstall 180 5月 29日 23:00 emagentfetchlet.trc
drwxrwx--- 2 oracle oinstall 512 5月 29日 23:14 nmcTNMS1521
-rw-r----- 1 oracle oinstall 4899969 5月 29日 23:26 emoms.log
-rw-r----- 1 oracle oinstall 4899969 5月 29日 23:26 emoms.trc
-rw-r----- 1 oracle oinstall 103897 5月 29日 23:26 emagent.trc
-rw-r----- 1 oracle oinstall 3581315 5月 29日 23:26 emdb.nohup
-rw-r----- 1 oracle oinstall 2260 6月 4日 14:51 emdctl.trc
bash-3.00$ tail -100f emdctl.trc
2011-05-29 22:58:20 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:58:30 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:1158): 不允许联接 (error = 146)
2011-05-29 22:58:55 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:01 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:06 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:11 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:16 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:20 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:26 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:31 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:35 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:41 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
2011-05-29 22:59:46 Thread-1 WARN http: snmehl_connect: connect failed to (tnms:3938): 不允许联接 (error = 146)
解决
bash-3.00$ emca -reconfig ports
EMCA 开始于 2011-6-4 14:55:39
EM Configuration Assistant, 10.2.0.1.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
输入以下信息:
数据库 SID: TNMS
是否继续? [yes(Y)/no(N)]: y
2011-6-4 14:57:14 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 /export/home/oracle/orcl/product/10gr2/cfgtoollogs/emca/emca_2011-06-04_02-55-38-下午.log。
2011-6-4 14:57:14 oracle.sysman.emcp.EMConfig perform
严重: 数据库实例不可用。
有关详细资料, 请参阅 /export/home/oracle/orcl/product/10gr2/cfgtoollogs/emca/emca_2011-06-04_02-55-38-下午.log 中的日志文件。
无法完成配置。 有关详细资料, 请参阅 /export/home/oracle/orcl/product/10gr2/cfgtoollogs/emca/emca_2011-06-04_02-55-38-下午.log 中的日志文件。
启动dbconsole
bash-3.00$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplication - An instance of Oracle Enterprise Manager 10g Database Control is already running.
无法访问
停止dbconsole
bash-3.00$ emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
查看dbconsole状态
bash-3.00$ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is not running.
重起dbconsole
bash-3.00$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ................. started.
------------------------------------------------------------------
Logs are generated in directory /export/home/oracle/orcl/product/10gr2/tnms_TNMS/sysman/log
bash-3.00$ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://tnms:1158/em/console/aboutApplicationOracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /export/home/oracle/orcl/product/10gr2/tnms_TNMS/sysman/log
bash-3.00$
emca -reconfig ports [-cluster] [参数]: 重新明确分配 Database Control 端口
-emca -reconfig dbcontrol -cluster [-silent] [参数]: 重新配置 RAC Database Control 部署
详细参看emca帮助文档
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/13488447/viewspace-697183/
,如需转载,请注明出处,否则将追究法律责任。