Thursday 21 June 2012

EM status pending or agent unreachable

After a recent Oracle Database service_name change, an installation of Oracle Enterprise Manager Database Control stopped being operable. As a quick fix I dropped and then recreated the repository to get the Database Control installation working.
All seemed well until I noticed a perpetual "Status Pending" message with the "Clock" symbol on the EM Home page. I returned to the problem a while later at which point the status had changed to "Agent Unreachable" with the "Disconnect" symbol. Upon further investigation I noticed that there were two agents installed. I suspected that EM DC was looking at the wrong one. After much diagnosis and many red herrings I finally discovered on EM, a link to a page to resolve the issue.
The "Clock" symbol

From the any page, select "Setup" on the top right, then the "Management Services and Repository" tab. At the bottom of the page is an "Alerts" panel. In this case an alert with the Metric Name "Target Count" had appeared. Clicking on the Target Count metric displays a "Duplicate Targets" page showing "Monitoring Agents" and "Conflicting Agents". On this page is a button to "Change the monitoring Agent". By selecting each "Internal Target Name" and pressing the button it was possible to one by one switch the monitoring agent of each target.
Whilst there are numerous other reasons why "Status Pending" or "Agent Unreachable" status messages may appear on the EM DC or GC Home page, none of the various information sources I reviewed was relevant to the problem at hand. The online documentation was scant on such troubleshooting and most MOS documents referred to RDA and EMDIAG as the omniscient sources of truth (very handy utilities I'm sure but no help for quick fixes unless you're familiar with them).
Suffice to say I'm glad there was a simple solution. Hope this helps others.
NB. Oracle EM Version 10.2.0.4.4 (packaged with Oracle Database Version 11.2.0.3.0)
See also; Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment [ID 1099271.1]

2 comments: