We’re in the process of implementing a load balancing server for our OMS cluster.  The migration itself consists of changing the REPOSITORY_URL and emdWalletSrcUrl addresses inside the $ORACLE_HOME/agent_inst/sysman/config/emd.properties file and then resecuring the agent — on each host in our environment.

How do I know when I’ve changed the upload destination on every host?  I need a scorecard.

The SYSMAN schema doesn’t contain a view containing this information but you can find the data in the table sysman.mgmt_emd_ping.  This SQL query maps the agents to their upload destination using that table.

SELECT LTRIM (
SUBSTR ( b.heartbeat_recorder_url, 0,
INSTR ( b.heartbeat_recorder_url, ‘.’ ) – 1 ),  ‘https://’ ) upload_dest,
SUBSTR ( a.target_name, 0, instr(a.target_name,’.’)-1 ) agent,
b.heartbeat_recorder_url,
a.target_name agent_url
FROM sysman.mgmt$target a, sysman.mgmt_emd_ping b
WHERE a.target_type = ‘oracle_emd’
AND a.target_guid = b.target_guid
ORDER BY upload_dest, target_name;

BTW: You can dispense with the first two values if you like (upload_dest and agent) that I’ve used to visually simplify the result set.

I’ve pasted this query into an Information Publisher view to avoid logins to the OMR repository database and scheduled the report to update daily.  You must grant select on the table to the mgmt_view user for use in the report.

GRANT SELECT ON SYSMAN.MGMT_EMD_PING TO mgmt_view;

UPLOAD_DEST AGENT HEARTBEAT_RECORDER_URL AGENT_URL
demopomsserver01 abcprod01 https://demopomsserver01.em.org:4903/empbs/upload abcprod01.em.org:3872
demopomsserver01 abcprod02 https://demopomsserver01.em.org:4903/empbs/upload abcprod02.em.org:3872
demopomsserver01 abctest02 https://demopomsserver01.em.org:4903/empbs/upload abctest02.em.org:3872
demopomsserver01 defprod01 https://demopomsserver01.em.org:4903/empbs/upload defprod01.em.org:3872
demopomsserver02 defprod02 https://demopomsserver01.em.org:4903/empbs/upload defprod02.em.org:3872
demopomsserver02 deftest01 https://demopomsserver01.em.org:4903/empbs/upload deftest01.em.org:3872
demopomsserver03 demotdb01b https://demopomsserver01.em.org:4903/empbs/upload demotdb01b.em.org:3872
demopomsserver03 demotdb04b https://demopomsserver01.em.org:4903/empbs/upload demotdb04b.em.org:3872
demopomsserver04 demotdb07b https://demopomsserver01.em.org:4903/empbs/upload demotdb07b.em.org:3872
demopomsserver04 demotdb08a https://demopomsserver01.em.org:4903/empbs/upload demotdb08a.em.org:3872
demopomsserver04 demotdb09a https://demopomsserver01.em.org:4903/empbs/upload demotdb09a.em.org:3872
demopomsserver04 demotdb09b https://demopomsserver01.em.org:4903/empbs/upload demotdb09b.em.org:3872
demopomsserver05 demotdb10a https://demopomsserver01.em.org:4903/empbs/upload demotdb10a.em.org:3872