oracle 10g 企业管理器无法打开解决方法
今天发现oracle 10g企业管理器无法打开，于是google，发现问题解决了。本质就是重新配置。步骤如下：
C:\Documents and Settings\Administrator>emctl status dbconsole
Environment variable ORACLE_SID not defined. Please define it.
C:\Documents and Settings\Administrator>set oracle_sid=testdb
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>emctl start dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://10.10.10.84:%EM_UP
LOAD_PORT%/em/upload/
.
C:\Documents and Settings\Administrator>emctl config
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Usage ::
emctl config console <fileloc> [<EM loc>]
where <fileloc> contains config entries.
emctl config [agent] addtarget [-f|-force] <fileloc> [<EM loc>]
where <fileloc> contains a definition of target to add,
and where -f or -force allows to overwrite an existing target.
If -f or -force is not specified, existing targets cannot be overwritten.
emctl config [agent] addtargets [-f|-force] <fileloc> [<EM loc>]
where <fileloc> contains a definition of targets to add
and where -f or -force allows to overwrite existing targets.
If -f or -force is not specified, existing targets cannot be overwritten.
emctl config [agent] modifytarget <fileloc> [<EM loc>]
where <fileloc> contains a new definition of target to modify
emctl config [agent] deletetarget <type> <name> [<EM loc>]
where <type>,<name> specify target type and name to delete
emctl config [agent] listtargets [<EM loc>]
lists all targets present in targets.xml
emctl config [agent] listcentralagents [<EM loc>]
lists the central agents this home is associated with
emctl config [agent] addcentralagent <centralAgentHomePath> [<EM loc>]
associates this home with a new central agent
emctl config [agent] removecentralagent <centralAgentHomePath> [<EM loc>]
removes the association of this home with a central agent
emctl config [agent] setcentralagents <centralAgent1> [<centralAgent2> ...]
sets the list of central agents this home is associated with
emctl config agent addTargetsToRepository <uploadFile> <update_on_dup (true |
false)>
uploadFile contains definition for targets
update_on_dup decides whether updating duplicate targets
This function is for central agent
<EM loc> is optional and can be used to operate on a different Oracle Home.
The centralagent commands do not apply in a agent-only home.
C:\Documents and Settings\Administrator>emctl config dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://10.10.10.84:%EM_UP
LOAD_PORT%/em/upload/
.
C:\Documents and Settings\Administrator>emctl config dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://10.10.10.84:%EM_UP
LOAD_PORT%/em/upload/
.
C:\Documents and Settings\Administrator>emca -config dbcontrol db
EMCA 开始于 2008-7-4 11:43:43
EM Configuration Assistant 10.2.0.1.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
输入以下信息:
数据库 SID: testdb
已为数据库 testdb 配置了 Database Control
您已选择配置 Database Control, 以便管理数据库 testdb
此操作将移去现有配置和默认设置, 并重新执行配置
是否继续? [yes(Y)/no(N)]: y
监听程序端口号: 1521
SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
SYSMAN 用户的口令: 通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
-----------------------------------------------------------------
已指定以下设置
数据库 ORACLE_HOME ................ D:\oracle\product\10.2.0\db_1
数据库主机名 ................ 10.10.10.84
监听程序端口号 ................ 1521
数据库 SID ................ testdb
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............
-----------------------------------------------------------------
是否继续? [yes(Y)/no(N)]: y
2008-7-4 11:44:29 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\testdb\e
mca_2008-07-04_11-43-42-上午.log。
2008-7-4 11:44:31 oracle.sysman.emcp.util.DBControlUtil stopOMS
信息: 正在停止 Database Control (此操作可能需要一段时间)...
2008-7-4 11:44:41 oracle.sysman.emcp.util.DBControlUtil startOMS
信息: 正在启动 Database Control (此操作可能需要一段时间)...
2008-7-4 11:45:21 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2008-7-4 11:45:21 oracle.sysman.emcp.EMDBPostConfig performConfiguration
警告: 无法创建 Database Control 快捷方式
2008-7-4 11:45:21 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为http://10.10.10.84:5500/em<<<<<<<<<<<
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2008-7-4 11:45:21
C:\Documents and Settings\Administrator>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://10.10.10.84:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...请求的服务已经启动。
请键入 NET HELPMSG 2182 以获得更多的帮助。
