Difference between revisions of "Grid Control"
From dbawiki
(→Definitions) |
(→Agent Unreachable) |
||
| Line 10: | Line 10: | ||
select username,program from v$session where LOWER (program) like 'emagent%'; | select username,program from v$session where LOWER (program) like 'emagent%'; | ||
If no rows selected, the agent is not running. | 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 | ps -ef|grep [a]gent | ||
| − | There should be 2 processes | + | There should be 2 processes. If only 1, kill it and restart the agent. |
Revision as of 19:21, 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. 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.
