Grid Control

From dbawiki
Revision as of 19:22, 22 November 2011 by Shb (talk | contribs)
Jump to: navigation, search

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. or

From Unix:
. oraenv
agent11g (how to find what SIDs are available on your machine)
emctl status agent
ps -ef|grep [a]gent

There should be 2 processes. If only 1, kill it and restart the agent.

emctl start agent