Setting Up Direct Alert Notification

Database Control displays all alerts on the Database Home page. However, you can optionally specify that Database Control provide you direct notification when specific alerts arise. For example, if you choose e-mail notification for critical alerts, and you have a critical threshold set for the system response time for each call metric, then you might be sent an e-mail message similar to the following:

Host Name=mydb.us.example.com
Metric=Response Time per Call
Timestamp=08-NOV-2006 10:10:01 (GMT -7:00)
Severity=Critical
Message=Response time per call has exceeded the threshold. See the
latest ADDM analysis.
Rule Name=
Rule Owner=SYSMAN

The e-mail message contains a link to the host name and the latest ADDM analysis.

By default, alerts in critical state such as DB Down, Generic Alert Log Error Status, and Tablespace Space Used are set up for notification. However, to receive these notifications, you must set up your e-mail information.

To set up your e-mail information:

1. From any Database Control page, click the Setup link, which is visible in the header and footer areas.

2. On the Setup page, select Notification Methods.

3. Enter the required information into the Mail Server section of the Notifications Methods page. Click Help at the bottom of the page for assistance.

   There are other methods of notification, including scripts and SNMP (Simplified Network Management Protocol) program interrupts (traps). The latter can be used to communicate with third-party applications.

   At this point, you have set up a method of notification, but you have not set up an e-mail address to receive the notification. To do so, complete the following steps.

4. From any Database Control page, click the Preferences link, which is visible in the header and footer areas.

5. On the Preferences page, select General. Click Add Another Row in the E-mail Addresses section to enter your e-mail address.

6. Click Test to verify that e-mail messages can be sent using the specified information. After the test completes, click OK.

7. (Optional) To edit notification rules, for example to change the severity state for receiving notification, select Rules under the heading Notification on the left-hand side of the page.

   The Notification Rules page appears. Click Help for more information about this page.