Viewing Alert Log Entries and Checking for Errors

You can use DBaaS Monitor to review the alert log periodically to verify that your database system is operating normally.

The alert log is a chronological log of messages including the following:

• Nondefault initialization parameters used at startup

• Administrative operations, such as STARTUP, SHUTDOWN, ARCHIVE LOG, RECOVER, and CREATE/ALTER/ DROP DATABASE/TABLESPACE

• Messages and errors relating to the functions of certain background processes, such as LGWR

• Internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60)

To view alert log entries:

1. On any DBaaS Monitor page, click Alerts from the Database drop-down menu.

2. Search for a specific value by selecting the display column in the first drop-down list, selecting the condition in the second drop-down list, and entering your search value in the box. Then, click the search icon.

The Alerts box on the DBaaS Monitor Home page has two sections, each of which can be clicked for further detail. One section indicates the total number of all messages. The other section indicates how many errors have been recorded in the alert log in the last 7 days. To view errors in the alert log:

1. On the DBaaS Monitor home page, click ERRORS in the Alerts box.

2. On the Alerts page select Type from the first drop-down list and enter your search criteria in the third field. Then, click the search icon.

   Errors recorded in the alert log are displayed.