How to Set Up Email Alerts From Oracle

Written by ginny putscher
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Set Up Email Alerts From Oracle
Setting up e-mail alerts from Oracle. (e-mail image by makuba from

In Oracle Database 10g, a feature referred to as Automated Database Diagnostic Monitoring (ADDM) is available to collect and analyse 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 e-mail 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.

Skill level:

Things you need

  • Oracle Enterprise Manager

Show MoreHide


  1. 1

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

  2. 2

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

  3. 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. 4

    Set up alerts to be e-mailed. Three pieces of information are required for the alerts to be e-mailed: enter the IP address of your network's SMTP mail server (for example, ""); 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 e-mails (for example, ""). Click "Apply" to save after the email configuration is entered.

  5. 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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.