Re: MGMT_DB_FEATUREUSAGE is empty

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Fri, 27 May 2016 01:11:13 +0000
Message-ID: <877B321F-B344-41A2-A30F-9C8562E3ACC9_at_lfg.com>



Dave,

I had the same issue. Go into the database target monitoring settings and click on feature usage and just go through all of the screens in OEM to re-save the feature usage options (you don't need to change anything). At the end, it will ask you to click OK to confirm, and then once it's done, your emctl command will show that it's collecting. It'll push the updates to the OMS once a day after that.

There are several bugs in the database related to feature usage collection, I can send some MOS notes if you're interested.

Thanks,
Scott

On May 26, 2016, at 18:40, Herring, David <HerringD_at_DNB.com<mailto:HerringD_at_dnb.com>> wrote:

The cursor you listed returns IS_ENABLED as "0" and the schedule as " "<Schedule> <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/> </Schedule>". I found MOS article 1970236.1 that says I need to make sure this feature is enabled for the repository yet when I check in the console it shows the same schedule, running every 24 hrs. But the test to check for this at the agent level doesn't return any rows:

% $AGENT_HOME/bin/emctl status agent scheduler | grep -i "feature"

Regards,

Dave

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Le, Binh T. Sent: Thursday, May 26, 2016 1:38 PM
To: rjoralist3_at_society.servebeer.com<mailto:rjoralist3_at_society.servebeer.com>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: MGMT_DB_FEATUREUSAGE is empty

Hi David,

Run this query against your OEM repository database check if you have the feature usage collection turn on.

I think 12c default is not collect this information also check to see at your target level (your database also need to collect this information too)

select t.target_name

,c.coll_name
,c.is<http://c.is>_enabled
,c.schedule_ex
from sysman.mgmt_targets t left join sysman.mgmt_collections c on t.target_guid = c.object_guid and c.coll_name like 'feature_usage_collection_item'
where t.target_type in ('rac_database','oracle_database')   and t.target_name like '%'||:your_database_name ||'%' order by t.target_name,c.coll_name;

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J Sent: Thursday, May 26, 2016 2:18 PM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: MGMT_DB_FEATUREUSAGE is empty

On 2016/05/26 11:45, Herring, David wrote: I have a request from management to pull feature usage statistics for all supported environments so I figured I'd use the view MGMT$DB_FEATUREUSAGE on all EMs. While the 11g views give me what I want, our 12c EMRs don't return anything as the underlying table MGMT_DB_FEATUREUSAGE is empty. The OMS is 12.1.0.4, db 12.1.0.2, all on RHEL 6.6. Anyone see this before and/or know how this table is populated? It looks like the data I'm expecting is in MGMT$CS_FEATURE_USAGE, which is new in 12c, but I can't be sure. I also have noted that other MGMT$DB_* views are populated so it appears to be just this one. I have these views in my 12.1.0.5 OMS respository, under the SYSMAN schema:

CM$MGMT_FEATURE_USAGE_ECM
MGMT$CS_FEATURE_USAGE
MGMT$DB_FEATUREUSAGE
MGMT$DB_FEATURE_USAGE

Of these, the last is empty, possibly a leftover from upgrades past. All of my DB targets are 11.2.0.3 and my EM DB Agent plugin is 12.1.0.8. As you've probably guessed, the underlying MGMT_DB_FEATUREUSAGE table to the MGMT$DB_FEATUREUSAGE view is populated. It's not an EM metric, so I'm not sure why this would not be populated (i.e. it's not a matter of a metric being disabled). Rich

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 27 2016 - 03:11:13 CEST

Original text of this message