OracleDBConsoleorcl

Database:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

问题描述：
重新安装了oracle 10g（由于本本经常带到客户现场，IP经常变化，在拔掉网线
在Localhost情况下安装），安装完成以后正常启动，到第二天发现不能启动dbconsole
服务。

在windows下启动如下：
C:Documents and SettingsAdministrator>net start oracledbconsoleorcl
OracleDBConsoleorcl 服务正在启动 .............
OracleDBConsoleorcl 服务无法启动。

发生服务特定错误: 2.

请键入 NET HELPMSG 3547 以获得更多的帮助。

查看dbconsole日志，在C:oracleproduct10.2.0db_1esoon-penn_orclsysmanlog目录下
OracleDBConsoleorclsrvc.log文件
其中esoon-penn为主机名

内容如下：
-------------- [OracleDBConsoleorcl] ------------
EMDROOT=C:oracleproduct10.2.0db_1
ORACLE_HOME=C:oracleproduct10.2.0db_1
EMDSTATE=C:oracleproduct10.2.0db_1esoon-penn_orcl
CONSOLE_CFG=dbconsole
TRACE_LEVEL=16
TIMEOUT=15
08/03/08 09:34:27 Start pending...
08/03/08 09:34:27 Verifying dbconsole is not started already. Command line "C:oracleproduct10.2.0db_1binemctl.bat" istatus dbconsole
08/03/08 09:34:32 dbconsole launch commandline is "C:oracleproduct10.2.0db_1binemctl.bat" istart dbconsole
08/03/08 09:34:32 Tracking process launch...
08/03/08 09:35:05 Received exitCode 3 from emctl istatus
08/03/08 09:35:05 dbconsole started
08/03/08 09:35:07 Recieved ServCtrlHdlr command, 4

从日志看是oracle 启动dbconsole的命令为emctl.bat istart dbconsole，马上在dos直接执行命令
C:Documents and SettingsAdministrator>emctl.bat istart dbconsole
Environment variable ORACLE_SID not defined. Please define it.
--没有设置oracle_sid马上设置，执行出现如下错误
--系统中存在C:oracleproduct10.2.0db_1esoon-penn_orcl目录，而不存在OC4J_DBConsole_192.168.10.168_orcl

C:Documents and SettingsAdministrator>set oracle_sid=orcl

C:Documents and SettingsAdministrator>emctl.bat istart dbconsole
OC4J Configuration issue. C:oracleproduct10.2.0db_1/oc4j/j2ee/OC4J_DBConsole_192.168.10.168_orcl not found.

查看网上帖子，都说修改emctl.bat文件参数中set EM_OC4J_HOME=C:oracleproduct10.2.0db_1oc4jj2eeOC4J_DBConsole

我想oracle不会这么笨吧，根据以上观察，可能是dns错误，在
C:WINDOWSsystem32driversetchosts文件中，
添加一行127.0.0.1 esoon-penn
启动正常

C:Documents and SettingsAdministrator>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://esoon-penn:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleorcl 服务正在启动 ................
OracleDBConsoleorcl 服务已经启动成功。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15761986/viewspace-1018691/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15761986/viewspace-1018691/