Tip 11. For Grid control, How to get the following results

Group Name     Target Name       Host Name
------------------------------------------------------------------
Grp1                       db1                       host1
Grp1                      db2                       host 1
Grp1                      db3                       host2
Grp2                      db4                       host2
Grp3                     +ASM1                 host1
....


A11:  This comes from mail list, I replied one approach.

A single group can include many members(targets), they can be
same target type or different target type. Some targets have
relationship with hosts(e.g. database instance, rac instance,
ASM instance,Listeners,,etc) others have not. So, user should
first understand the relationship between group,target and
associate target.

Let's see an example.

First you should know the relationship between these tables:
"MGMT_TARGETS", "MGMT_TARGET_TYPES",
"MGMT_TARGET_ASSOCS".

Then build single queries, Finally combine them.

For example:

(Optional) Step 1: Get the target type definition

select target_type from mgmt_target_types where NLS_UPPER(type_display_name)=NLS_UPPER('group')


Step 2: Get the target guid, group name of your created groups

select rawtohex(target_guid),target_name from mgmt_targets where target_type
in (select target_type from mgmt_target_types where NLS_UPPER(type_display_name)=NLS_UPPER('group'))


Step 3: Get the relationship between source and accoc targets

select T2.target_name,Rawtohex(T1.ASSOC_TARGET_GUID)
from MGMT_TARGET_ASSOCS T1, MGMT_TARGETS T2
where T2.target_guid=T1.source_target_guid
and T1.source_target_guid in
(select target_guid from mgmt_targets where target_type='composite')


Step 4: Get the relationship between host and specified targets

select target_name, host_name from mgmt_targets
where target_guid in (Q3) ...


Step 5: Combine these queries, using self-join on tables:

select T2.target_name as "Group Name",
T3.target_name as "Target Name" ,T3.host_name as "Host Name" from
MGMT_TARGET_ASSOCS T1, MGMT_TARGETS T2,
(select target_guid,target_name, host_name from mgmt_targets) T3
where T2.target_guid=T1.source_target_guid
and T1.source_target_guid in
(select target_guid from mgmt_targets where target_type='composite')
and T3.target_guid=T1.ASSOC_TARGET_GUID

lovewinter对oracle10g的em研究很深了
我最近一周左右吧，一直在捣鼓gridcontrol 10.2.0.2在windows2003 sp1上的安装。中间遇到了很多的问题。最后呢，也算是达到了自己的目的吧，gridcontrol 10.2.0.2在windows2003 sp1也算是可以正常使用了
我会在今天写一下在安装过程中的排措过程，表达非常混乱，不过这也是我这种水平的人能表达出来的了。
以后还得对gridcontrol做更深的研究。
lovewinter这个帖子我是研究过多遍的。
但没有真正的全部试验过，只是有了问题，来查找看有没有处理办法。
有时候，总是再想。做oracle也算年数不少了。几乎有时间就研究oracle，oracle给自己带来什么了？发财了？没有。每天还在为生计犯愁。

up,先增加点分数

继续

in my laptop, there are 2 databases,  one is ora10, another is test,
how to configure DB control to manage both of then,
db control , not grid control.....?

QUOTE:

---

最初由 mugen 发布
in my laptop, there are 2 databases,  one is ora10, another is test,
how to configure DB control to manage both of then,
db control , not grid control.....?

---

DB control 是针对每个DB的，可以指定不同的port来进入不同的管理介面呀。

how? use command  or edit some cfg files?

maybe you can try to use EMCA command.

db control 是针对instance的,每个instance对应一个db console 服务
grid control 是典型的三层结构,先安装OMS和repository, 然后在各个站点上安装agent进行管理.

至于你说的两个数据库需要管理,最好是安装grid control,然后在各个节点安装agent即可.
在一个站点上启动两个db console 服务是很费资源的,就算内存足够,cpu的调度也是个问题.

agent 可以discover and manage 节点上的许多资源(database,listener,rac instance,
application server and third party products).

[ 本帖最后由 LoveWinter 于 2008-5-21 21:03 编辑 ]