RE: EM12c Rules and Rule Groups
Date: Mon, 29 Aug 2016 23:28:09 +0000
Message-ID: <CY1PR0201MB1868B230A00AC1724AF07958D4E10_at_CY1PR0201MB1868.namprd02.prod.outlook.com>
Oh I'm still on my 12.1.0.4 to 12.1.0.5 crusade, one that I started months ago and am finally getting back to. Doc 1664074.1 keeps getting more and more *exciting*.
Regards,
Dave
[cid:image001.png_at_01D05044.5C2AEE60]
Dave Herring
DBA
103 JFK Parkway
Short Hills, New Jersey 07078
Mobile 630.441.4404
dnb.com<http://www.dnb.com/>
[cid:image002.png_at_01D05044.5C2AEE60]<http://www.facebook.com/DunBradstreet>[cid:image003.png_at_01D05044.5C2AEE60]<http://twitter.com/dnbus>[cid:image004.png_at_01D05044.5C2AEE60]<http://www.linkedin.com/company/dun-&-bradstreet>[cid:image005.png_at_01D05044.5C2AEE60]<http://www.youtube.com/user/DunandBrad>
From: Peter Sharman [mailto:pete.sharman_at_oracle.com]
Sent: Monday, August 29, 2016 6:12 PM
To: Herring, David; oracle-l_at_freelists.org
Subject: RE: EM12c Rules and Rule Groups
Yup, 13c or not (that I'm aware of), I'm afraid.
Having said that, there have been a lot of issues fixed since 12.1.0.4, so you really should be upgrading anyway. Maybe the next time the requirement comes up you can use it to push for testing the upgrade path. ;)
Pete
[Oracle logo]
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095<tel:+61262924095> | | Mobile: +61414443449
Email: pete.sharman_at_oracle.com<mailto:pete.sharman_at_oracle.com> Twitter: @SharmanPete LinkedIn: au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!" Bruce Pihlamae, long term Oracle DBA
From: Herring, David [mailto:HerringD_at_DNB.com]
Sent: Tuesday, August 30, 2016 05:29 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: EM12c Rules and Rule Groups
Folks,
Has anyone come up with a good method for dumping out all details of a Rule Set and it's Rule(s) defined in EM12c? For example, let's say I have on 1 EM12c (12.1.0.4 in the US) installation an Incident Rule Set SYSDBA_DATABASE_SYSTEM for "Database System" target types. This Rule Set has a Rule for 20 or so metrics and another for Target Availability. I'd like to create the exact same configuration on a 2nd EM12c (say in the UK). I believe that 13c has the ability to export/import Rule Sets but 12c doesn't.
This isn't a frequent activity (other than perhaps a monthly comparison to make sure everything is configured as we intended) but even for a one-time deal it's quite a pain. As far as I can tell metrics for a Rule can't be sorted, whether viewing or editing. I can copy-paste the metrics into Excel and sort them there but that's rather lame. "emcli" doesn't have a function for this unfortunately.
I did find in EM_RULES.RL_EXPRESSION what looks like the detail of the rule although it's all 1 CLOB of code that looks like "function ... && ew.asve("metric_group" , "dataguard") && ew.asve("metric_column" , "dg_status"))...". I could try to REGEXP... details out of it or wrap a cursor in bash and awk/grep/sed the details out but that all seems way too labor-intensive for something that shouldn't be, at least in my opinion.
Thx.
Regards,
Dave
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 30 2016 - 01:28:09 CEST
- image/png attachment: image002.png
- image/png attachment: image003.png
- image/png attachment: image004.png
- image/png attachment: image005.png
- image/png attachment: image006.png
(image/jpeg attachment: image007.jpg)
