Customizing Oracle alert log monitoring

The alert log workspaces are used to monitor the Oracle messages from the Oracle alert log. You can customize the monitoring setting to monitor the messages that you want, and set the severity level for each message.

To customize the monitoring settings for Oracle alert log, complete the following steps:

1. Open the Host_name_rz_Instance_name_msgid.properties properties file for Oracle alert log monitoring. On Windows 32-bit systems, the file is in the install_dir\TMAITM6 directory. On Windows x64 systems, the file is in the install_dir\TMAITM6_x64 directory. On UNIX and Linux systems, the file is in the install_dir/config directory. Where:

   install_dir

   Installation directory of the Oracle Database Extended agent.

   Host_name

   Host name of the system where the agent is running.

   Instance_name

   Name of the Oracle Database Extended agent.

2. Edit the file as required. The file contains regular expressions that are used to match the message IDs. You can add a new regular expression, comment an existing regular expression, or change the severity level for a regular expression. Each line must be written in the following format: RegularExpression=ServerityLevel. For example, ORA-0*44[0-9]=1.
   You have the following four choices for the severity level:

   • 1, error
   • 2, warning
   • 3, information
   • 4, miscellaneous
   • 5, ignore
   For the detailed syntax for regular expressions, see ICU regular expressions.
3. Save your changes and close the file.