今天發現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 以獲得更多的幫助。

轉載于:https://www.cnblogs.com/yangkunlisi/archive/2011/08/26/2154188.html

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的oracle 10g 企业管理器无法打开解决方法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。