Difference between revisions of "Grid Control"
From dbawiki
(→Grid Control) |
(→Definitions) |
||
| Line 4: | Line 4: | ||
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA | * 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 | * 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 | ||
Revision as of 19:06, 22 November 2011
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
