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

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Mobile: +61414443449 Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"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
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-l