Re: Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?

Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?You used this one yet for exp?

grep "without warnings" ${LOG_FILE} > /dev/null 2>&1

   if [ $? != 0 ]
   then

      mailx -s "Failure in ${LOG_FILE}" ${MAILLIST} < ${LOG_FILE}    fi

need to have statistics=none in your parameter file or you'll get an error. i don't know if error checking on imp is required. there are so many errors that could arise that reviewing the logfile might be the only check. but that doesn't mean you couldn't check for file existence etc.

Mike
----- Original Message -----
From: Marquez, Chris
To: oracle-l_at_freelists.org
Sent: Thursday, August 18, 2005 4:14 PM
Subject: Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?

All,

• My skill level: I have written my share of shell scripts...mostly basic. A few "loops" and "if" statements here and there. 90% of my shell scripts have been to do things with Oracle; EXP/IMP, SQLPLUS, RMAN, etc. Mostly starting programs and handling external files. I have never written a case statement, nor used error handling (other than standard out).
• My task: I have been given the task/challenge to convert or add to existing EXP/IMP scripts error handling and return codes. I found some tutorials on the web and began playing with "trap" and "Exit status" in some basic shell scripts. I fear my biggest problem is that beyond "how to" I don't know what is possible (with shell scripts & Oracle).

OK, OK, OK...my task (specifically).
1.) I need to know (or test) if my script completes successfully and assign a value.

2.) I need to know if/where my script dies/aborts/terminates in the middle and assigning a value....rolling variable?

     "if step A complete then v_stats=...if step B complete then v_stats=..."

3.) I need to get a positive or negative return code from Oracle EXP/IMP utility and pass it to shell script (#2 above).

• Regarding Oracle EXP/IMP; Not sure what I am asking here...what are the possibilities if any for Oracle EXP/IMP utility return codes? And is a return code completely worthless anyway? Would I really need/parse/get the result "Export completed without warnings" to *know* the Oracle EXP/IMP returned successfully?

I'm all ears...and ready for code samples-scripts, docs, links and references.

Thanks,

Chris Marquez
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l