Windows XP下Oracle 10g EM启动问题解决小记

始 - 运行 - 输入services.msc - 启动OracleDBConsoleorcl服务提示有误。

手工从cmd命令行启动：

C:/Documents and Settings/wangnc>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.

设置Oracle_sid环境变量：

C:/Documents and Settings/wangnc>set oracle_sid=orcl

C:/Documents and Settings/wangnc>emctl start dbconsole
OC4J Configuration issue. C:/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_sz-wangncD.cn.linecom.com_orcl not found.

还是不行，到目录 C:/oracle/product/10.2.0/db_1/oc4j/j2ee 下发现只有OC4J_DBConsole_localhost_orcl目录，并没有OC4J_DBConsole_sz-wangncD.cn.linecom.com_orcl这样的目录，然后设置oracle_hostname：

C:/Documents and Settings/wangnc>set oracle_hostname=localhost

C:/Documents and Settings/wangnc>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://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleorcl service is starting.............
The OracleDBConsoleorcl service could not be started.

A service specific error occurred: 2.

More help is available by typing NET HELPMSG 3547.

提示奇怪的错误，根据提示看看原因：

C:/Documents and Settings/wangnc>NET HELPMSG 3547

A service specific error occurred: ***.


EXPLANATION

A service-specific error occurred.

ACTION

Refer to the Help or documentation for that service to determine the problem.

看来不是oracle_hostname的原因，取消设置：

C:/Documents and Settings/wangnc>set oracle_hostname=

C:/Documents and Settings/wangnc>set oracle_hostname
Environment variable oracle_hostname not defined

尝试设置C:/WINDOWS/system32/drivers/etc/hosts 文件，再次启动还是不行：

C:/Documents and Settings/wangnc>emctl start dbconsole
OC4J Configuration issue. C:/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_sz-wangncD.cn.linecom.com_orcl not found.

由于Oracle是在公司安装的，现在我在外头使用宽带上网，DHCP动态分配IP，所以干脆把网线拨了，并确认：

C:/Documents and Settings/wangnc>ipconfig

Windows IP Configuration


Ethernet adapter Local Area Connection:

        Media State . . . . . . . . . . . : Media disconnected

再次手工启动dbconsole：

C:/Documents and Settings/wangnc>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://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleorcl service is starting............................
The OracleDBConsoleorcl service was started successfully.

终于启动了，然后再次插上网线，并确认：

C:/Documents and Settings/wangnc>ipconfig

Windows IP Configuration


Ethernet adapter Local Area Connection:

        Connection-specific DNS Suffix . : local
        IP Address. . . . . . . . . . . . : 192.168.10.63
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 192.168.10.1

现在查看dbconsole服务的状态，虽然看似有误，但是登陆http://localhost:1158/em/已经没有什么问题了。

C:/Documents and Settings/wangnc>emctl status dbconsole
OC4J Configuration issue. C:/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_sz-wangncD.cn.linecom.com_orcl not found.

--End--