Grid Control
From dbawiki
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
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.
From Unix: ps -ef|grep [a]gent
There should be 2 processes