Monitoring messages in Oracle alert log
sushk 1100006DS0 Visits (12610)
This is a brief discussion of monitoring of alert log messages using ITCAM Extended Oracle Agent.
Hopefully you will be able to answer following questions after reading this entry.
How can the agent be used to get an alert when specific message ID appears in the alert log?
Why are some messages in Oracle alert log not being displayed by the agent?
How can the message IDs monitored by Oracle agent be customized?
1) Alert message IDs pattern specification
Agent reads a message ID pattern file specified for the Oracle agent instance, and uses it to filter messages seen in alert log.
This instance specific file can be customized for each agent instance.
The setting =1 means severity of 'Error', =2 means 'Warning' etc. The setting of =5 is special, it means that the message is to be ignored or 'filtered out' as opposed to 'filtered in' as for other settings.
Read the header information in the pattern file for other severity settings.
***Note: If you want to modify the msgid file for all Oracle agent instances in an installation directory, then instead of modifying individual msgid files for the instances, you can modify the <ITM
2) Alert Log workspace
When a message is 'filtered in' by the agent, it is displayed in Alert Log workspace of the agent.
The message ORA-00445 is displayed in TEP workspace Alert Log, under the Alert Log Detail view, with Severity Level set to 'Error'.
3) Customizing msgid.properties file
Suppose if you want to monitor message ID ORA-3297. The msgid.properties file does not contain a matching pattern.
4) Attributes to use in situations
The attribute group KRZ_
As an example, consider that you want to get an alert for all ORA-3* message IDs, except when the number is 3214 and 3296. Use following steps to implement this monitoring.
Add the following pattern in <hos
Next, create a situation with following formula based on RDB Alert Log Details attribute group :
( SCAN(Message ID) == 'ORA-3' AND Message Number != 3214 AND Message Number != 3296)