RE: sync EM metrics with database metrics

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 11 Jul 2014 10:51:42 -0400
Message-ID: <53BFC1BE.3406.000B.1_at_gcrta.org>

Clone was w/RMAN duplicate. Agent does monitor the server just does not monitor for any metrics that should also be in dba_thresholds without us doing our work-around.

>>> Courtney Llamas <courtney.llamas_at_oracle.com> 7/11/14 10:42 AM >>>

Curious - Was the clone done manually?  

You can try running a clearstate from the agent in question: emctl clearstate agent  

If that doesn’t work, we can identify the collection name, which I think in this case is UserLocksCollection ./emctl status agent scheduler | grep oracle_database|grep <db name>

2014-07-11 07:25:06.040 : oracle_database:emrep:instance_throughput_10i
2014-07-11 07:25:08.570 : oracle_database:emrep:Recovery_Area
2014-07-11 07:25:09.325 : oracle_database:emrep:Response
2014-07-11 07:25:09.970 : oracle_database:emrep:rac_global_cache_10i
2014-07-11 07:25:13.540 : oracle_database:emrep:activity_pending
2014-07-11 07:25:21.543 : oracle_database:emrep:Database_Resource_Usage_10i
2014-07-11 07:25:24.403 : oracle_database:emrep:dgprimarydb_collection
2014-07-11 07:25:29.575 : oracle_database:emrep:incident_meter
2014-07-11 07:25:31.239 : oracle_database:emrep:log_full
2014-07-11 07:25:59.889 : oracle_database:emrep:observer_11g
2014-07-11 07:26:52.386 : oracle_database:emrep:wait_sess_cls_10i
2014-07-11 07:26:58.000 : oracle_database:emrep:wait_bottlenecks_10i
2014-07-11 07:30:38.184 : oracle_database:emrep:UserLocksCollection
2014-07-11 07:31:13.327 : oracle_database:emrep:Temporary File Status
2014-07-11 07:31:35.297 : oracle_database:emrep:memory_usage_coll_item
2014-07-11 07:31:55.756 : oracle_database:emrep:db_inst_pga_alloc_11g
2014-07-11 07:32:02.054 : oracle_database:emrep:instance_efficiency_10i
2014-07-11 07:33:26.503 : oracle_database:emrep:system_response_time_per_call_10i
 

And then rerun that collection.
emctl control agent runCollection <TARGETNAME>:oracle_database UserLocksCollection emctl upload agent    

--
Regards, Courtney

Courtney Llamas | Principal Member of Technical Staff, Strategic Customer Programs Phone: +1 2814108258 | Mobile: +1 8324720596 Oracle Systems and Applications Management 1200 Smith Street | Houston, TX 77002
Oracle is committed to developing practices and products that help protect the environment  

From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Friday, July 11, 2014 8:00 AM
To: Bobby Curtis
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: sync EM metrics with database metrics  

That doesn't help the problem where the metric already exists in the EM but not in the database dba_thresholds table as result of a clone.

>>> Bobby Curtis <curtisbl_at_gmail.com> 7/11/14 8:58 AM >>>
Jeff,  

Have you looked at monitoring templates in OEM12c? Monitoring templates allow you to set default metrics and then apply them or use them with new targets that are added to OEM 12c.  

Bobby    

On Jul 11, 2014, at 8:23, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:

Given that we have some EM 12C metrics set, i.e. user blocks and they appear in the dba_thresholds view. The database is then cloned with RMAN and the metric no longer appears in dba_thresholds. As a result, we go into EM and change the metric value for the missing metrics to a new value and then back to the original value to cause EM to update the dba_thresholds view. Is there a way to cause EM 12c to resync its values with the database other than having to do a dummy value change?  

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
.      

.

.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 11 2014 - 16:51:42 CEST