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

Comment below ...
 

----------------- 
Ron Reidy 
Lead DBA 
Array BioPharma, Inc. 
303.386.1480 

-----Original Message-----
From: Marquez, Chris [mailto:cmarquez@xxxxxxxxxxxxxxxx]
Sent: Thursday, August 18, 2005 3:47 PM
To: Reidy, Ron; oracle-l@xxxxxxxxxxxxx
Subject: RE: Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit 
Status?



Ron,

Thanks I appreciate the comments.
I have not looked into 'typeset' command yet (maybe if I do it will answer my 
next question?

I used a simple EXP shell script I have and forced the 3 possible outcomes;
     Export terminated successfully with warnings.
     Export terminated successfully without warnings.
     EXP-00000: Export terminated unsuccessfully

"Export terminated..." should produce "0"
and
"Export terminated unsuccessfully" should produce "1"
however " $? " is always "0" for each?

This snip shell code
==========
exp <<EOFexp >> $log_file 2>&1  \
.......
exit
EOFexp

echo 'EXP ERROR CODE ' >> $log_file 2>&1
[Reidy, Ronald] The above will reset $? to 0 (assuming success).  Change your 
code to something like this:

typeset -i rc=-1

exp <<eof >>$log 2>&1

...

exit

eof

rc=$?

if [[ $rc -eq 0 ]]; then

  ## egrep for the "unsuccessfull" error message

  if [[ `/bin/egrep -c "your_text_here" $log` -ge 1 ]]; then

    # handle the warning

  fi

else

  # handle the non-0 error messages

fi

 
echo $? >> $log_file
==========

Either "EXP-00000: Export terminated unsuccessfully" != "Export terminated 
unsuccessfully"
or EXP is never populating " $? " correctly?


Reference;
Doc ID:         Note:281725.1
Subject:        Database Utilities - Export and Import Exit Codes (Errorlevel)

Chris Marquez
Oracle DBA


-----Original Message-----
From: Reidy, Ron [  <mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx> 
mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx]
Sent: Thu 8/18/2005 4:19 PM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit 
Status?

Comments below ...


-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [  <mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Marquez, Chris
Sent: Thursday, August 18, 2005 2:14 PM
To: oracle-l@xxxxxxxxxxxxx
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.
[Reidy, Ronald] Use the 'typeset' command  to declare a variable (typeset -i 
rc).  At the end oif the exp/imp command assign the value of the return code 
(rc=$?).  Test it from there.

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).
[Reidy, Ronald] exp/imp return positive codes only.  0 = OK, anything else 
indicates a warning or failure

 - Regarding Oracle EXP/IMP;
Not sure what I am asking here...what are the possibilities if any for Oracle 
EXP/IMP utility return codes?
[Reidy, Ronald] See above.
And is a return code completely worthless anyway?
[Reidy, Ronald] No.
Would I really need/parse/get the result "Export completed without warnings" to 
*know* the Oracle EXP/IMP returned successfully?
[Reidy, Ronald] Spool to a log file.  Use /bin/egrep to look for the specific 
lines you would like to see.

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

Thanks,

Chris Marquez
Oracle DBA




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.





This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Other related posts: