我新装了oracle10g后,出现以下问题:
(1)通过plsql登录system用户,长期等待状态,即登录不了;
(2)web访问http://机器名:1158/em或http://localhost:1158/em或http://172.0.0.1:1158/em均无法打开;
(3)在dos命令里执行:emctl start dbconsole,提示:Environment variable ORACLE_SID not defined. Please define it.于是再执行set ORACLE_SID=orcl,后执行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://6470c4ebbc99447:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...请求的服务已经启动。
请键入 NET HELPMSG 2182 以获得更多的帮助。
但通过执行emctl status dbconsole,提示:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://6470c4ebbc99447:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
总之,企业管理器怎么也启动不了,不知问题出在哪了?
(1)通过plsql登录system用户,长期等待状态,即登录不了;
(2)web访问http://机器名:1158/em或http://localhost:1158/em或http://172.0.0.1:1158/em均无法打开;
(3)在dos命令里执行:emctl start dbconsole,提示:Environment variable ORACLE_SID not defined. Please define it.于是再执行set ORACLE_SID=orcl,后执行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://6470c4ebbc99447:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...请求的服务已经启动。
请键入 NET HELPMSG 2182 以获得更多的帮助。
但通过执行emctl status dbconsole,提示:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://6470c4ebbc99447:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
总之,企业管理器怎么也启动不了,不知问题出在哪了?
重启之看看是否有什么提示信息。
在本地计算机 无法启动 OracleDBConsoleorcl服务。
错误1053:服务没有及时相应启动或控制请求。
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://SUIZI:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory D:\oracle\product\10.2.0\db/SUIZI_ggz/sysman/log
C:\Documents and Settings\ggz>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://SUIZI:1158/em/console/aboutApplication
Agent Version : 10.1.0.4.1
OMS Version : 10.1.0.4.0
Protocol Version : 10.1.0.2.0
Agent Home : D:\oracle\product\10.2.0\db\SUIZI_ggz
Agent binaries : D:\oracle\product\10.2.0\db
Agent Process ID : 1148
Agent Process ID : 1148
Agent URL : http://SUIZI:3938/emd/main
Started at : 2010-03-22 17:08:18
Started by user : SYSTEM
Last Reload : 2010-03-22 17:08:18
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 58
Size of XML files pending upload(MB) : 0.40
Available disk space on upload filesystem : 68.64%
Agent is already started. Will restart the agent
This will stop the Oracle Enterprise Manager 10g Database Control process. Conti
nue [y/n] :y
OracleDBConsoleggz 服务正在停止.........
OracleDBConsoleggz 服务已成功停止。
C:\Documents and Settings\ggz>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://SUIZI:1158/em/console/aboutApplication
没有启动 OracleDBConsoleggz 服务。请键入 NET HELPMSG 3521 以获得更多的帮助。
C:\Documents and Settings\ggz>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://SUIZI:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleggz 服
务正在启动 ..................
OracleDBConsoleggz 服务已经启动成功。
C:\Documents and Settings\ggz>
测试了下,应该是你的服务并未启动成功。查看下启动日志。
emagent.log:
2010-03-22 14:58:02 Thread-3664 启动代理 10.1.0.4.1 (从 D:\oracle\product\10.2.0\db_1) (00701)
2010-03-22 14:59:36 Thread-3664 目标 {orcl, oracle_database} 中断: 无法及时计算动态属性。 (00155)
2010-03-22 15:00:20 Thread-3664 已成功启动 EMAgent (00702)
2010-03-22 15:22:15 Thread-1180 启动代理 10.1.0.4.1 (从 D:\oracle\product\10.2.0\db_1) (00701)
2010-03-22 15:23:56 Thread-1180 目标 {orcl, oracle_database} 中断: 无法及时计算动态属性。 (00155)
2010-03-22 15:24:20 Thread-1180 已成功启动 EMAgent (00702)
2010-03-22 15:45:59 Thread-1180 EMAgent 已正常关闭 (00703)
2010-03-22 16:55:47 Thread-1408 启动代理 10.1.0.4.1 (从 D:\oracle\product\10.2.0\db_1) (00701)
2010-03-22 16:57:25 Thread-1408 目标 {orcl, oracle_database} 中断: 无法及时计算动态属性。 (00155)
2010-03-22 16:58:02 Thread-1408 已成功启动 EMAgent (00702)
2010-03-22 17:19:23 Thread-1408 EMAgent 已正常关闭 (00703)
2010-03-22 18:10:09 Thread-3992 启动代理 10.1.0.4.1 (从 D:\oracle\product\10.2.0\db_1) (00701)
2010-03-22 18:11:43 Thread-3992 目标 {orcl, oracle_database} 中断: 无法及时计算动态属性。 (00155)
2010-03-22 18:12:09 Thread-3992 已成功启动 EMAgent (00702)