Database Message Log 

Definition

This submonitor in the SAP/Oracle Database Monitor lets you check the database message log.

Use

You choose Detailed Analyses ®  Exceptional Conditions ® Database Message Log.

To generate the required display of the message log, you specify the parameters:

·        Select content

¡        Read all messages: all messages are displayed

¡        Read all msg. w/o logswitch and checkpoint: all messages are displayed except log-switch and checkpoint messages

·        Select time

·        Entries starting from: enter the date and time from which message are displayed

·        All available: all available messages are displayed

·        Max lines to be displayed: the display is restricted to the maximum number of lines

Structure

The message log is displayed in chronological order.

On Oracle Real Application Cluster (RAC), when you select Total under DB Instances, a merged message log for all instances is displayed. The submonitor adds the column Instance ID to the list.

You can use the scrolling functions, such as Day, to quickly find the required part of the message log.

Trace files in the message log display are highlighted. You can display the content of a trace file by selecting the relevant row and choosing Show trace file.

Integration

To use this submonitor, your system must meet at least one of the following requirements:

·         Message log

Access Method to Message Log	Requirement
BRTOOLS using file type alert_log	BRTOOLS must be installed on the database instances. All administrative files, such as servernames, must be maintained correctly.
BRTOOLS using file type alert_log with specified sysid	BRTOOLS must be installed on the database instances. This method is more tolerant of missing administrative file entries than the previous method.
BRTOOLS using file type file	BRTOOLS have to be installed on the database instances. This method is more tolerant of missing administrative file entries than the previous methods.
RFC call and READ dataset	The instance server must also host a SAP application server. The data file must be accessible by the application server.

·         Trace file

The submonitor tries to read the trace file using BRTOOLS. Therefore, you must make sure that BRTOOLS is installed on the database instance and that all administrative files are maintained correctly.

For more information, see SAP Notes 80689 and 446172.

Make sure that the trace file has not been deleted if you want to view it.