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

作者在 2008-10-22 11:54:44 发布以下内容
 
开始 - 运行 - 输入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--
数据库技术 | 阅读 22835 次
文章评论,共0条
游客请输入验证码
浏览71344次