Grid Control

Definitions

• OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
• OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
• OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

Get rid of an agent that won’t go away in the Grid screens:

emctl stop agent
exec mgmt_admin.cleanup_agent('<myserver>:<port>')
emctl start agent

Get rid of targets that won’t go away in the Grid screens:

exec mgmt_admin.delete_target('target_name','target_type’)

See mgmt_targets table in sysman schema for list of known targets.

Re-discover targets

cd $ORACLE_HOME/bin
./agentca -d

Agent Unreachable

• Is the agent running?

From SQL*Plus:

select username,program from v$session where LOWER (program) like 'emagent%';

If no rows selected, the agent is not running. or

From Unix:
. oraenv
agent11g (how to see [[which databases are running on the machine]])
emctl status agent

ps -ef|grep [a]gent

There should be a handful. If only a few, kill them and restart the agent.

 emctl start agent

Check the agent log in $ORACLE_HOME/sysman/log

To list targets known to an agent:

emctl config agent listtargets

It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:

emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

Some useful Metalink Master Documents related to Grid Control

• Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
• Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
• How to Run the RDA against a Grid Control Installation [ID 1057051.1]
• How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
• Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
• Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
• Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
• Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
• Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]