Help - Search - Members - Calendar
Full Version: send ORA-error alert through mail
Oracle DBA Forums > Oracle > Oracle Forum
abhijitsatam
hi experts,

can any one please tell me how to create trigger or procedure for send all ORA- error alert mail from database. if any ORA - error comes in ALERT_SID.log then after trigger send the mail to my mail id rolleyes.gif


SteveC
That's basic shell scripting. You can tail the last however many lines of an alert log at whatever frequency you want, grep for ORA errors and send an email via mail or mailx, depending upon your platform.

http://dba-oracle.com/googlesearchsite_pro...shell+scripting
abhijitsatam
Hi, Steve

thanks for quick reply. at my system mailx is not configure.... because of that i want database trigger or procedure to send mail using smtp.
SteveC
You are asking about how to re-instrument Oracle and alerts based on metrics, which is practically the entire point of using Database Control in the first place. How is it you can be running Oracle on a server and turn around and hobble the server by not enabling the mail send system? That makes no sense whatsoever.

http://dba-oracle.com/googlesearchsite_pro...atabase+control
burleson
Hi,

Yes, you can use utl_smtp to send e-mails, see here:

http://www.dba-oracle.com/t_utl_smtp_utility.htm

Good Luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.