When running the SQL Query, seeing the Secondary MOM is not specified correctly:
select external_id, history from (
select vertex_id, count(1) as history from appmap_vertices
where start_time > (sysdate - 5)
group by vertex_id
order by 2 desc) t
join appmap_id_mappings m on t.vertex_id=m.vertex_id
where rownum < 20;
EM_MOM:[email protected]
1
EXTERNAL_ID
--------------------------------------------------------------------------------
HISTORY
----------
EM_MOM:[email protected]
1
EM_COLLECTOR:XPVWAP2330|[email protected]
1
EM_CONNECTION:xpvwap2333.test.broadcom.com
XPVWAP2329 is the Primary MOM
XPVWAP2330 is the Secondary MOM
Release : 10.7.0
Component : APM Agents
The secondary MOM configured with different roles ;
Please choose either standalone EM , Cluster Single MOM, or Secondary MOM in HA.
It also might have the Master ETC property has been changed
ts_entity table contains :
1. Stop the Enterprise Manager.
2. SQL> delete from ts_entity;
SQL> commit;
3. Start the EM