How to Set Up Email Alerts From Oracle

Setting up email alerts from Oracle.

In Oracle Database 10g, a feature referred to as Automated Database Diagnostic Monitoring (ADDM) is available to collect and analyze database performance statistics. With ADDM, it is possible to detect and alert an administrator or manager monitoring the database for potential management and performance problems. By default, when a management or performance issue occurs, these alert notifications appear on to the Enterprise Management Control main screen, but with additional configurations, these alerts can be sent by email to whoever is monitoring the database.



When setting up the Notification alert in Oracle Database 11g with the ADDM, the email configuration has been enhanced slightly to include the optional authentication information. In the event that your server requires authentication, the username, the password and confirmation of the password are optional to satisfy the authentication of your Simple Mail Transfer Protocol (SMTP) server to send messages.

Things You'll Need

• Oracle Enterprise Manager

Instructions

1. Connect to Oracle Database Control. Click "All Programs > Oracle Home 10g > Database Control."

2. Log on to the Enterprise Management. Enter your username and password, then click "OK."

3. Display the Notification Methods screen. Click the "Setup" link at the top of the Enterprise Management Database Control screen, then click the "Notification Methods" link.

4. Set up alerts to be emailed. Three pieces of information are required for the alerts to be emailed: enter the IP address of your network's SMTP mail server (for example, "smtp.acme.com"); the name of the user from whom the email address will be sent (for example, "OEM"); and the email address of the user sending the notification emails (for example, "[e-mail]"). Click "Apply" to save after the email configuration is entered.

5. Test mail server set up. Click "Test Mail Servers" button on the "Notification Methods" screen. A confirmation will verify that the configuration you have entered works.

References

• "OCA: Oracle 10g Administration I Study Guide;" Chip Dawes, Bob Bryla, Joseph C. Johnson and Matthew Weishan; 2005
• "Oracle 11g For Dummies;" Chris Zeis, Chris Ruel and Michael Wessler; 2009