Oracle10G的EM采用了web方式，并且分成了2个产品，database control和grid control。Grid control需要下载单独的光盘安装。ITPUB个人空间 hJj.G&S H+ak#A
在用DBCA建库的时候，可以选择是否启用dbcontrol，启用的话需要在数据库中建立一个sysman的schema，用于保存EM的一些数据，这个就是EM的资料库(repository)。使用命令行工具emca可以创建，修改，重建或者删除dbcontrol的配置。

由于要在数据库中建EM资料库，数据库和监听都必须已经启动并正常工作。

常用的命令ITPUB个人空间 K!g+S6W w*W*_S:{
emca -repos create     创建一个EM资料库
qT5KEP},O,V;G%Fy#Y0emca -repos recreate 重建一个EM资料库
#Z { vc'ew,oKoV0emca -repos drop        删除一个EM资料库

emca -config dbcontrol db   配置数据库的 Database ControlITPUB个人空间&]"x'E:I+[[
emca -deconfig dbcontrol db  删除数据库的 Database Control配置

emctl start dbconsole      启动EM console服务
o ] g4v8]v?0emctl stop dbconsole       停止EM console服务

emca -reconfig ports命令重新配置db control和agent的端口。通过查看$ORACLE_HOME/install/portlist.ini文件可以知道当前dbcontrol正在使用的端口，默认dbcontrol http端口1158，agent端口3938。ITPUB个人空间a+f&O#DnLV
如果要重新配置端口，可以使用如下命令：
-H2K
o X'h/P0Z:T0emca -reconfig ports -dbcontrol_http_port 1159ITPUB个人空间%XPnT_#W
emca -reconfig ports -agent_port 3939

调试过程中出现的问题ITPUB个人空间dJvuF7n1[U
(1) 由于安装数据库是设置的shared_pool_size太小，导致 emca -config dbcontrol db时出错。后重新设置shared_pool_size=80M后解决问题。ITPUB个人空间j BbA9P]7J
(2) 安装完成后连接到oem速度很慢，经常报ORA-12518错误，已打开listner日志，目前尚未解决。

| [o:~+M*R m0调试过程记录
m8K9nEq^1c0C:\>emctl status dbconsoleITPUB个人空间 hCr$vM"B7^6]%g6P
OC4J Configuration issue. d:\ora10g/oc4j/j2ee/OC4J_DBConsole_hy.myoa.com_oraITPUB个人空间0D `Y"Ac2r Z-vI
10g not found.

C:\>
U;CCyt/ty0C:\>ITPUB个人空间p{(iDa'uz
XQ;D
C:\>emca -repos recreate

EMCA 开始于 2008-5-22 13:59:02ITPUB个人空间e8B r+kIe
EM Configuration Assistant 10.2.0.1.0 正式版ITPUB个人空间If+Pv/D
版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:
9oi;@)^+~0t;o.m'V0数据库 SID: ora10gITPUB个人空间z y5`/VN.Q2? s(w
监听程序端口号: 1521
5m7x \4`3?6}D0SYS 用户的口令:ITPUB个人空间B.I4G)\ h;E"F
SYSMAN 用户的口令:

是否继续? [yes(Y)/no(N)]: yes
r_|:_ g'N02008-5-22 13:59:13 oracle.sysman.emcp.EMConfig performITPUB个人空间K R,nN
L
信息: 正在将此操作记录到 d:\ora10g\cfgtoollogs\emca\ora10g\emca_2008-05-22_01-59
oo+}/P BbO y+o0{'M0-01-下午.log。
"hF"Ar,mQ02008-5-22 13:59:14 oracle.sysman.emcp.EMReposConfig dropRepository
eF0GY~V:II_0信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...ITPUB个人空间D:S
Qp Gw6e
2008-5-22 13:59:37 oracle.sysman.emcp.EMReposConfig invokeITPUB个人空间&IhF2SDK4x3K
信息: 已成功删除资料档案库
+d!L/D!l H bF02008-5-22 13:59:37 oracle.sysman.emcp.EMReposConfig createRepositoryITPUB个人空间%J6x+[
]2H3BT
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...ITPUB个人空间:K5w [D klo f,h
2008-5-22 14:05:33 oracle.sysman.emcp.EMReposConfig invoke
0O ^:CS7W0信息: 已成功创建资料档案库
9x"b4INk9X^0已成功完成 Enterprise Manager 的配置ITPUB个人空间#Sa~d-^
EMCA 结束于 2008-5-22 14:05:33

C:\>ITPUB个人空间 ^)v5h.I:m(l p#d
C:\>ITPUB个人空间#YTQ}H
C:\>emca -config dbcontrol db

EMCA 开始于 2008-5-22 14:07:06ITPUB个人空间 Y\4P+MI7Zk)q
EM Configuration Assistant 10.2.0.1.0 正式版
t UL x,vG otI;b$s0版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:ITPUB个人空间+Nh%s7G#u:K
数据库 SID: ora10gITPUB个人空间[:X([i;w\l
监听程序端口号: 1521ITPUB个人空间%h/a$W B4VVSu&t
SYS 用户的口令:
[3UF:Ub T*?4R1b0DBSNMP 用户的口令:ITPUB个人空间 XW.C2Y t`#?K$n0O
SYSMAN 用户的口令:
P:B;JS2no'M'[0通知的电子邮件地址 (可选):hy@esp.comITPUB个人空间(z Yj;O cUY|
通知的发件 (SMTP) 服务器 (可选): mail.esp.comITPUB个人空间S"i
y-m9o^:s
-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE_HOME ................ d:\ora10g

数据库主机名 ................ hy.myoa.com
6q(k*_c{3Y yq0监听程序端口号 ................ 1521ITPUB个人空间 }w6W'N)J_"x;E;[0I
数据库 SID ................ ora10gITPUB个人空间/b%xay/@6CZ
通知的电子邮件地址 ...............hy@esp.comITPUB个人空间0z'_9FA!Ru-Ed
通知的发件 (SMTP) 服务器 ............... mail.esp.com

-----------------------------------------------------------------ITPUB个人空间%W l F` G9J
是否继续? [yes(Y)/no(N)]: yes
\C'\5Ee`02008-5-22 14:08:38 oracle.sysman.emcp.EMConfig perform
5z3Cl-\+_U T"K&n)F"X}0信息: 正在将此操作记录到 d:\ora10g\cfgtoollogs\emca\ora10g\emca_2008-05-22_02-07ITPUB个人空间HN@fD1Qx&kh
-06-下午.log。
BB+YJm8YP:n02008-5-22 14:08:39 oracle.sysman.emcp.DatabaseChecks performReposChecks
0nG s{r L k8z0警告: 'shared_pool_size' 必须大于等于 80 MB。
2u C b%D `Ur1Ff02008-5-22 14:08:54 oracle.sysman.emcp.util.PlatformInterface executeCommandITPUB个人空间 A8F t&r"s
警告: 执行 CMD /C d:\ora10g\bin\emctl.bat deploy dbconsole d:\ora10g\hy.myoa
\|*I`H5}0jTEt0.com_ora10g hy.myoa.com:3938 hy.myoa.com ora10g  时出错ITPUB个人空间9b2V+]pA1e
2008-5-22 14:08:54 oracle.sysman.emcp.EMConfig performITPUB个人空间*s1goImq W3j6C
y
严重: 实例化 EM 配置文件时出错
gX0c9Rf3a!]0有关详细资料, 请参阅 d:\ora10g\cfgtoollogs\emca\ora10g\emca_2008-05-22_02-07-06-
rW5i(TxB|0下午.log 中的日志文件。ITPUB个人空间5n.S ^KEv5i7Z
无法完成配置。 有关详细资料, 请参阅 d:\ora10g\cfgtoollogs\emca\ora10g\emca_2008-ITPUB个人空间pZ
z A \)}:]8tr(X
05-22_02-07-06-下午.log 中的日志文件。

C:\>emca -config dbcontrol db

EMCA 开始于 2008-5-22 14:10:23ITPUB个人空间ru6l.K1G`@
z
EM Configuration Assistant 10.2.0.1.0 正式版ITPUB个人空间 S.YM^gbz
版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:
R3PI9No:b0数据库 SID: ora10gITPUB个人空间h-[8c,V1N]C;D
已为数据库 ora10g 配置了 Database ControlITPUB个人空间0dL+c4@h ` {
您已选择配置 Database Control, 以便管理数据库 ora10g
XbR#Y-UMu-S0此操作将移去现有配置和默认设置, 并重新执行配置ITPUB个人空间;S(HI$K&R_f
是否继续? [yes(Y)/no(N)]: yes
u-f f qF)s0监听程序端口号: 1521
.G6PE#Zp$[2P2X~0SYS 用户的口令:ITPUB个人空间HT)t0Y'It A\+V_
DBSNMP 用户的口令:ITPUB个人空间-~p$m;w(f6Q_,z
SYSMAN 用户的口令:ITPUB个人空间*u YZ7E;|!{ Js
SYSMAN 用户的口令: 通知的电子邮件地址 (可选):hy@esp.comITPUB个人空间/g8X$xZ9{X sIn
通知的发件 (SMTP) 服务器 (可选): mail.esp.comITPUB个人空间~)u ~L({SGy
-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE_HOME ................ d:\ora10g

数据库主机名 ................ hy.myoa.comITPUB个人空间"`7@` U-}SnXaU$EB
监听程序端口号 ................ 1521ITPUB个人空间Z9}5Y!EF"b@
数据库 SID ................ ora10g
-r)Q4G'@4FR0通知的电子邮件地址 ...............hy@esp.com
eZUey s(s0通知的发件 (SMTP) 服务器 ............... mail.esp.com

-----------------------------------------------------------------ITPUB个人空间%f4q5e2bZ&i+Z;p
是否继续? [yes(Y)/no(N)]: yesITPUB个人空间9J bFI*aJ:D
2008-5-22 14:10:53 oracle.sysman.emcp.EMConfig performITPUB个人空间0Rn F#}
\'F7ZW2\
信息: 正在将此操作记录到 d:\ora10g\cfgtoollogs\emca\ora10g\emca_2008-05-22_02-10
4s(nQo5| @;E:rx4S{0-23-下午.log。
NJawl02008-5-22 14:10:55 oracle.sysman.emcp.util.DBControlUtil stopOMSITPUB个人空间9O/_8]&nM7k2]~%DD6z/^%Q
信息: 正在停止 Database Control (此操作可能需要一段时间)...
S$LVm/I,b/q:][lt02008-5-22 14:11:04 oracle.sysman.emcp.util.DBControlUtil startOMS
J!O'\yM X|0信息: 正在启动 Database Control (此操作可能需要一段时间)...ITPUB个人空间osJT(v0q ~
2008-5-22 14:12:04 oracle.sysman.emcp.EMDBPostConfig performConfigurationITPUB个人空间#z-P;q'k1@LB'x)?^4W
信息: 已成功启动 Database Control
s2RQ9X{R`]R {02008-5-22 14:12:04 oracle.sysman.emcp.EMDBPostConfig performConfiguration
T!Mo*?'ugCG:Z0警告: 无法创建 Database Control 快捷方式ITPUB个人空间5c.R%l7X|r4f s.I
2008-5-22 14:12:04 oracle.sysman.emcp.EMDBPostConfig performConfigurationITPUB个人空间fo?b0H
信息: >>>>>>>>>>> Database Control URL 为http://hy.myoa.com:5500/em<<<<<<<ITPUB个人空间R9W5}^P6in
<<<<ITPUB个人空间#N1iK,K3xU$k
已成功完成 Enterprise Manager 的配置
c9V@9R(a*n0EMCA 结束于 2008-5-22 14:12:04

C:\>emctlITPUB个人空间K9^:? c5i/B
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
L-@Su
I0Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
8p2I+B$vSP p0Invalid arguments

Unknown command option
;fN(Q x(Q0Usage::ITPUB个人空间5w_A!] E
B
   Oracle Enterprise Manager 10g Database Control commands:
:DF|^1J5v0       emctl start| stop| status| setpasswd dbconsoleITPUB个人空间V4nh-nFFpu
       emctl secure

       emctl set ssl test|off|on em
6B7d:d~ V4fd"B5S0       emctl set ldap ITPUB个人空间'n A!U q?)fhEP7U
emctl blackout options can be listed by typing "emctl blackout"
,YA Eb%o-K(oZ*P0emctl config options can be listed by typing "emctl config"ITPUB个人空间 OfVzP~
emctl secure options can be listed by typing "emctl secure"ITPUB个人空间9J(d.jD$xjs*d'qM
emctl ilint  options can be listed by typing "emctl ilint"ITPUB个人空间/jL6TLi
emctl deploy  options can be listed by typing "emctl deploy"

C:\>emctl status dbconsoleITPUB个人空间u"z,S9i:tjr |
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
`v*V+E$z0D7u0Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
D-O1b1w!l6O"O9i}0http://hy.myoa.com:5500/em/console/aboutApplicationITPUB个人空间[6o @^c
Oracle Enterprise Manager 10g is running.ITPUB个人空间I q^B h+[
------------------------------------------------------------------
u9i!p"g5@"UA)`F!hJ0Logs are generated in directory d:\ora10g/hy.myoa.com_ora10g/sysman/log

C:\>ITPUB个人空间:o^XIy
C:\>

**************************

I had the same issue. After the OEM policy violations were listed i did this:ITPUB个人空间gaY6],Df(?
C

SK&]8Fe3[r GD I0as sys as sysdba
B
iZ#LC-ej L3M0
2KP n_:n m|&E;Z z$T0revoke execute on UTL_HTTP from public;ITPUB个人空间Kmg,w3[*P,e[:@
revoke execute on UTL_SMTP from public;
2G9D(]"e"o0revoke execute on UTL_TCP from public;ITPUB个人空间*Q2[ d,]}&c&`:c O
revoke execute on DBMS_RANDOM from public;
w] iTq-|mx]0revoke execute on UTL_FILE from public;
X't/O[.| a P%|8{ux0
k U8l}eKT`0E0Which royally screwed up OEMITPUB个人空间6d!^3CSFc sX~
3 basic steps
!S)B+Y9f5v!i,|01- grant execute to necessary usersITPUB个人空间'JM |e?
2- recompile invalid objectsITPUB个人空间KM{:uR z(w3_c
3- refresh the agentITPUB个人空间x6W-S Br(Q+Y

u_6W,p)w/A4Y3s0See METALINKITPUB个人空间~.x3SP9K
Note:291113.1
4Qjqt.fFX)e+u0Note:315283.1ITPUB个人空间y?X-?/u _ N"v6}

(d,Z1FU vhF3a9M#e'eW01. Log into the repository database as sys:ITPUB个人空间 Ls8^ ZSd J$g
grant execute on sys.utl_smtp to sysmanITPUB个人空间L H%F J O5{n.C
grant execute on sys.utl_tcp to sysmanITPUB个人空间p.l| U*?F)RzCT1zd
ITPUB个人空间,JU N.XV3E;s5Y
2. alter package sysman.emd_notification compile;
%t \/x t jk0
/Jp m@^}3d0And some other schemas need grants as well -
I$C4gzn*{HX0ITPUB个人空间bX |!A P3K9i G|[M
grant execute on utl_file to xdb;
7`gr4p%\*Jb~ H0grant execute on sys.utl_file to DMSYS;ITPUB个人空间u/rl4j
TVT~\
etc......
2Oc\oHd2Dr k0zX%d0
&t"`Ldr0]W0Then recompile invalid objects in db using utlrp.sql found here =
1\xP|f7{5yk0
Jwj`wml HI|0$ORACLE_HOME/bla/bla/RDBMS/ADMIN/utlrp.sqlITPUB个人空间 m| fV%|/N+@1|a
ITPUB个人空间-T8o C'b"Q_g4p
Then refresh the agentITPUB个人空间S pG'b+N `,YJ'E!G
ITPUB个人空间Y)d,}#I,F S Mm
emctl clearstate agent
|N0r$v)t#W m.x0wait around 30 minutes for the state to clearITPUB个人空间1zz-O&ri*d6y
ITPUB个人空间x|c$`D%~9R@
That worked for me - Your mileage may vary

****************

Mohammed,
wi/rT'Q X d$?T0ITPUB个人空间 lh ygb S*M
Thank you for your help, but I've found the problem. It turns out I'm the victim of a bug in which the OC4J file orion-web.xml is not correct. Its classpath entries appear to point to Oracle testing libraries. The solution is to have a backup of the file and replace it after installing. Fortunately, one of my co-workers had run into the same problem and had the file available.ITPUB个人空间 OC&z&i/JW G#g;Ug
I gather that there's a bug, but even knowing what the problem is, I haven't been able to find it. If I do, I'll write it here.
M-]7V:_)dc-Jc0

Hey!
*gv N nJIR0ITPUB个人空间W$T+]h)t{#wl&?@
Thank you so much for the answer!!! I've been troubled with the same problem for a couple of weeks already..
~ L1}QP0
Pw)gm&W;f-y0Luckily, I had another instance+dbconsole running, so I copied the file on top of the one in the newly created folder, restarted the dbconsole and it worked!!!
,a%n#F+{9}Dx\0