In this post I will show about how e-mail can be send from oracle if any critical events happen.
With Enterprise Manager the task is very simple. With this you can easily send email if any oracle related problem happens. Like Tablespace full, Any oracle error, listener issue, performance problem etc.
Step 1: At first step you need to setup sender mail address, your SMTP server address and sender identifier.
i)On the Enterprise Manager Home page click setup link which is on the upper most right corner.
ii)..../em/console/admin/rep/userAdmin window appears. On the Setup tab click on the Notification Methods.
iii)The several boxes appears.
Outgoing Mail (SMTP) Server: Here post your SMTP server address. On my system I gave
192.168.1.1.
Identify Sender As: This is the identity of sender. I gave in this box
Arju.
Sender's E-mail Address: This is thrid box. Define from whom the mail will be sent. I gave here
prothoma@....comiv)On the right side click on
Test Mail Servers button A new window will come. If it display message similar like
Test Results
192.168.1.1: Test succeeded - You will also need to verify that a test e-mail has been received by prothoma@ya....com
Then this step is correct.
Step2:In this step you will assign the mail address of the users to whom notification will be sent. To do this,
i)On the Enterprise Manager page click on preferences link which is on the upper most right corner.
ii)Under general tab type SYS password and confirmed password. Then under E-mail Addresses menu click
add another row button and specify the email address to whom notification will be send.
ii)Then click on Test. A new window will appear displaying messge
.....@....com: Test succeeded - You will also need to verify that a test e-mail has been received
Now check the mail address to see whether actually mail is sent or not.
If you got mail to .....@....com address from prothoma@ya....com then you have successfully configured notification.
Step3:i)On the Enterprise Manager page click on preferences link which is on the upper most right corner.
ii)You then specify rules and schedules in of the notifications.
iii)Click on rules and then select
Listener Availability or Host Availability and Critical States or Database Availability and Critical States and then click
assign methods button and check the box send me e-mail and click ok.
iv)Notification ScheduleNext, you will need to define your notification schedule. EM will NOT send you email notifications
if you do not have a schedule defined.
A notification schedule is used to represent your on-call schedule. It tells EM two things:
(a) the day and time you should be contacted and
(b) the email addresses to be used during those times.
Any time slot that is left empty in the schedule means that EM should NOT send you email
notifications, even though alert may occur during that time.
It is important to note that the schedule you specify will automatically repeat.
In a nutshell I can say "Setting up email notifications for alerts" needs following steps.
Step I. Setup the mail servers
Step II. Setup EM user accounts for your administrators
Step III. Each EM user should define their own notification settings
a) E-mail addresses -From Preferences
b) Notification Schedule
Step IV. Define and subscribe to Notification Rules
Related Documents How to get port number list of EM and isqlplus In EM connection fails with ERROR: NMO not setuid-root (Unix-only) Connect to EM though normal user
