客户数据库项目从oracle 9i数据库升级到oracle10g后,oracle em在节点1启动不成功,节点2可以正常启动。
节点1启动时报错如下:
[oracle@zhgsdb1 ~]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, Oracle Corporation.All rights reserved.
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
[oracle@zhgsdb1 ~]$
1.查看em的状态
[oracle@zhgsdb1 ~]$ emctl status dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, Oracle Corporation.All rights reserved.
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory /oracle/app/oracle/product/10.2/zhgsdb1_CTAIS1/sysman/log
显示没有运行。
2.尝试关闭em
[oracle@zhgsdb1 ~]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, Oracle Corporation.All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
--- Failed to shutdown DBConsole Gracefully ---
failed.
提示关闭失败。
3.重建EM
重建后还是错误提示一样。
4.安装8350262补丁
安装8350262补丁后,问题还是一样,节点1em依旧启动不成功。
5.寻求oracle技术支持,开tar
Oracle的建议是:
On both nodes
1) emctl stop dbconsole
2) ps -ef | grep OC4J ==> kill any processes found related to this dbcontrol
3) ps -ef | grep agent ==> kill any process found related to dbcontrol's agent
通过掉oc4j进程,
em在节点1可以正常启动。
em使用正常。
3结论和建议
遇到些自己解决不了的问题,可以寻求oracle技术支持,包括开tar,发贴等。