RE: Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Aug 2005 16:04:40 -0600
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:
