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:
Other People Are Reading
Things you need
- Oracle Enterprise Manager
Connect to Oracle Database Control. Click "All Programs > Oracle Home 10g > Database Control."
Log on to the Enterprise Management. Enter your username and password, then click "OK."
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.
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, "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 e-mails (for example, "email@example.com"). Click "Apply" to save after the email configuration is entered.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for