RE: EM12c Rules and Rule Groups

From: "Herring, David" <HerringD@xxxxxxx>
To: Peter Sharman <pete.sharman@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 29 Aug 2016 23:28:09 +0000

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@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@01D05044.5C2AEE60]<http://www.facebook.com/DunBradstreet>[cid:image003.png@01D05044.5C2AEE60]<http://twitter.com/dnbus>[cid:image004.png@01D05044.5C2AEE60]<http://www.linkedin.com/company/dun-&-bradstreet>[cid:image005.png@01D05044.5C2AEE60]<http://www.youtube.com/user/DunandBrad>

From: Peter Sharman [mailto:pete.sharman@xxxxxxxxxx]
Sent: Monday, August 29, 2016 6:12 PM
To: Herring, David; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx<mailto:pete.sharman@xxxxxxxxxx>  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@xxxxxxx]
Sent: Tuesday, August 30, 2016 05:29 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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

References:
- EM12c Rules and Rule Groups
  - From: Herring, David
- RE: EM12c Rules and Rule Groups
  - From: Peter Sharman

RE: EM12c Rules and Rule Groups

Other related posts: