|
-
Oracle crash alert to pager/mobile of DBA
Our database is 24*7. Some body told me that if a Oracle database crashes at night(or any time), it can be configured to give an alert to pager/mobile of it's DBA. Is it possible. If it is possible, can anybody give the procedure to configure Oracle database to give an alert, when it crashes.
-
no the database cant, the tools which monitor the database are the things that do this - typically by sending out smtp alerts
-
 Originally Posted by davey23uk
no the database cant, the tools which monitor the database are the things that do this - typically by sending out smtp alerts
the database is the first to be configured to enable Email Notification(SMTP-outgoing mail server-i.e.mailam.yourcomp.com, dba's e-mail-i.e. yourname@am.yourcomp.com).
If the db wasn't configured to do this during creation of the db, I think you can use emca, and include like this:
../bin/emca -config dbcontrol .... -EMAIL_ADDRESS yourname@am.yourcomp.com -MAIL_SERVER_NAME mailam.yourcomp.com
then verify it with your e-mail administrator if email forwarding to mobile is configured. (must have a mobile phone carrier-telco).
I think it is also available with yahoo.com.
---------------
-
might as well use this link:
UTL_MAIL
---------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote