Printable View
Hi !
I want to trap all errors while my script is running. My script has sqlplus, exp,imp etc...
I want all errors in one file and then mail it to xyz.
Is anybody knows about user_errors table. When errors are recorded in that ? How I can make use of it ?
Echo all the actions of the scripts and capture into a log. When the script completed, have a job that mails the log to xyz. Simple, but could be complex depending upon what are all the scripts,tasks you are running and running at OS/DB level.
User should be notify if and only if errors occurs during execution . It's unix script.
Recorded errors are what ? DB errors/OS errors ?
If system errors check for the return codes, database/sql errors check for possible failure errors. Use sed/awk and find the strings in the log that says the task is successfull or not.
recorded errors are ORA error, PLSQL error , EXP error , IMP error. Yes I am trying now awk, sed.
if you send me syntes to use awk or sed
Bevare that with imp, exp and sqlldr some messages that you would expect to be piped to standard output (STDOUT)are actually written to standard error (STDERR) queue....