While the script approach is excellent, and you have gotten several good answers on how to use it, might I suggest looking into event triggers? If you are running 8i or above (not 8.1.5, it's buggy on this), you can create a database level trigger ON ERROR. If you have Java turned on for your system you can have Oracle email you the error directly. Otherwise you can use a daemon on the system to pick up the email duties. There are a few errors that are ignored, but they are the kind of thing that should be ignored (like programs passing characters to number parameters).
The only errors this is going to miss are catastrophic, i.e. when you get a core dump that kills SMON the trigger won't fire because the instance is already down. For that kind of thing only OS scripts will help. Regards, Chris Gait -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
