Enterprise Manager Generic (MOSC)

MOSC Banner

Metric and threshold regex parsing

edited Mar 15, 2011 3:46AM in Enterprise Manager Generic (MOSC) 1 commentAnswered
 Does the EM metric and threshold fields support look-ahead capacities in its regex parser? EM 10.2.0.5 psu3

 

For example, one of the defaults is to include only ORA-0600, 7445, and 4xxx in generic alert log errors with the following regex:

 

Generic Alert LOG Error MATCHES     warning=“ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]” critical=””

 

If the regex parser supports look-ahead then the following would filter out 600 and 7445 from critical alerts, when entered into the critical field:

 

Generic Alert LOG Error MATCHES     warning=“ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]” critical=”^(?!.*?(600|7445)).+$”

 

I know that 10g there is the Alert Log Filter which works just fine, but with 11g db the recommendation is to set the “set_agent_property” verb (bulletin id 949858.1). Which is combersome compared to using a simple regex if possible.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center