IBM Support

Situation for alert log monitoring with Extended Oracle agent

Question & Answer


Question

How to create a situation which will fire when Severity level=Error and ORA-xyz messages are seen in the alert log?

Answer

To create a situation which will fire when Severity level=Error and ID ORA-600 messages are detected in the alert log, refer to the following directions:

*IF *VALUE KRZ_RDB_ALERT_LOG_DETAILS.Severity_Level *EQ Error

*AND *SCAN KRZ_RDB_ALERT_LOG_DETAILS.Message_ID *EQ '600'

Note: Make sure to use the SCAN operator for the Message ID statement.

[{"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.3;6.3.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ITCAM Extended Agent for Oracle Database 5724V09OR v6.3","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21515020