Difference between revisions of "Grid Control"

From dbawiki
Jump to: navigation, search
(Agent Unreachable)
Line 13: Line 13:
  
 
See mgmt_targets table in sysman schema for list of known targets.
 
See mgmt_targets table in sysman schema for list of known targets.
 +
===Re-discover targets===
 +
<pre>
 +
cd $ORACLE_HOME/bin
 +
./agentca -d
 +
</pre>
 
==Agent Unreachable==
 
==Agent Unreachable==
 
* Is the agent running?
 
* Is the agent running?
 
  From SQL*Plus:
 
  From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
+
<pre>
 +
select username,program from v$session where LOWER (program) like 'emagent%';
 +
</pre>
 
If no rows selected, the agent is not running.
 
If no rows selected, the agent is not running.
 
or
 
or
From Unix:
+
<pre>
. oraenv
+
From Unix:
agent11g (how to see [[which databases are running on the machine]])
+
. oraenv
emctl status agent
+
agent11g (how to see [[which databases are running on the machine]])
 +
emctl status agent
  
ps -ef|grep [a]gent
+
ps -ef|grep [a]gent
 +
</pre>
 
There should be a handful. If only a few, kill them and restart the agent.
 
There should be a handful. If only a few, kill them and restart the agent.
 +
<pre>
 
  emctl start agent
 
  emctl start agent
 +
</pre>
  
 
'''Check the agent log in $ORACLE_HOME/sysman/log'''
 
'''Check the agent log in $ORACLE_HOME/sysman/log'''
Line 32: Line 43:
 
=== [[Backend WLS or EM application seems to be down]] ===
 
=== [[Backend WLS or EM application seems to be down]] ===
 
=== To list targets known to an agent: ===
 
=== To list targets known to an agent: ===
emctl config agent listtargets
+
<pre>
 +
emctl config agent listtargets
 +
</pre>
 
It looks at the file $AGENT_HOME/sysman/emd/targets.xml
 
It looks at the file $AGENT_HOME/sysman/emd/targets.xml
  
 
Manually add targets by editing this file and running:
 
Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml
+
<pre>
 +
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml
 +
</pre>
  
 
Check state and upload directories under $AGENT_HOME/sysman/emd for .err files
 
Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

Revision as of 16:26, 7 February 2014

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

Backend WLS or EM application seems to be down

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]