DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Error traping !!!

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    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 ?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    User should be notify if and only if errors occurs during execution . It's unix script.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

  5. #5
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    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

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width