EM12c Rules and Rule Groups
Date: Mon, 29 Aug 2016 19:28:43 +0000
Message-ID: <CY1PR0201MB1868AD014622591E555D77F2D4E10_at_CY1PR0201MB1868.namprd02.prod.outlook.com>
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 Mon Aug 29 2016 - 21:28:43 CEST