PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit

PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit

2005-09-01 - By Marquez, Chris

Reply: 1 2 3 4 5 6 7 8 9 10 >>

Guys, I'm stuck?

I have two scripts;
- export_simple_script_wrapper.sh
- export_simple_script.sh

export_simple_script.sh seems to work every time and in the logs shows the
correct "$RC" (=$?) every time for the right failure (or success).

export_simple_script_wrapper.sh works, by calling export_simple_script.sh but
the log output and "if" logic proves that it is always getting success "0" when
export_simple_script.sh tells other wise.

I have provided (I hope) enough log and script info below for your help in
finding my problem.

Thanks in advance,

Chris Marquez
Oracle DBA

++++++++++++++++++++++++++++++++
export_simple_script_wrapper.sh
++++++++++++++++++++++++++++++++

###################
# ERROR HANDLING & RETURN CODES
###################
# RETURN CODE: Set initial Return Code - RC for this script.
RC=1
echo 'RETURN CODE: Set initial Return Code - RC for this script.' >> $log_file
2>&1
echo $RC >> $log_file

cleanup()
{
echo cleaning up
echo "RETURN CODE: $RC"
}

trap 'cleanup; exit $?' EXIT

########################
# EXECUTE SCRIPT LOGIC: 1
########################
typeset -i RC=`/bin/sh /tmp/export_simple_script.sh`
if [[ $RC -ne 0 ]]; then
exit
else
echo ' ' >> $log_file
echo 'ORACLE EXPort SUCCEEDED!: '$RC >> $log_file 2>&1
echo $RC >> $log_file
echo ' ' >> $log_file
fi

# RETURN CODE: Show EXPort Return Code - RC: EXPort RETURN CODE.
#RC=$?
echo 'RETURN CODE: Show EXPort Return Code - RC: EXPort RETURN CODE.' >> $log
_file 2>&1
echo $RC >> $log_file

---THIS CODE WORKS EVERY TIME AND WHILE THE OUT IS ALWAYS THE CORRECT "RC",
"RC" IS NEVER PASSED CORRECTLY TO "export_simple_script_wrapper.sh"

++++++++++++++++++++++++++++++++
export_simple_script.sh
++++++++++++++++++++++++++++++++
########################
# EXECUTE SCRIPT LOGIC: 1
########################

exp <<EOFexp >> $log_file 2>&1 \
...
exit
EOFexp

# RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE.
RC=$?
echo 'RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE.' >> $log
_file 2>&1
echo $RC >> $log_file

if [[ $RC -eq 1 ]]; then
echo ' ' >> $log_file
echo 'ORACLE EXPort FAILED!: '$RC >> $log_file 2>&1
echo ' ' >> $log_file

elif [[ $RC -eq 0 ]]; then
echo ' ' >> $log_file
echo 'ORACLE EXPort SUCCEEDED!: '$RC >> $log_file 2>&1
echo ' ' >> $log_file

else
echo ' ' >> $log_file
echo 'ORACLE EXPort Utility STOPPED!: '$RC >> $log_file 2>&1
echo ' ' >> $log_file

fi

exit $RC

++++++++++++++++++++++++++++++++
TWO EXAMPLE RUNS AND LOG OUTPUT
++++++++++++++++++++++++++++++++

(#1.)
---FORCE "export_simple_script.sh" - KILL EXP PROCESS
[oracle@(protected) tmp]$ sh export_simple_script_wrapper.sh
/tmp/export_simple_script.sh: line 75: 30047 Killed exp USERID=system
/orcl9imanager FULL=Y ...<<EOFexp
exit
EOFexp
cleaning up
RETURN CODE: 0

[oracle@(protected) tmp]$ more export_simple_script_wrapper.sh.log
RETURN CODE: Set initial Return Code - RC for this script.
1

ORACLE EXPort SUCCEEDED!: 0
0

[oracle@(protected) tmp]$ more exp.log
...
. . exporting table MON_ALERT_MESSAGES 1000 rows exported
. . exporting table MON_CONF
RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE.
137

ORACLE EXPort Utility STOPPED!: 137

(#2.)
---FORCE "export_simple_script.sh" - BAD ORACLE PASSWORD

[oracle@(protected) tmp]$ sh export_simple_script_wrapper.sh
cleaning up
RETURN CODE: 0

[oracle@(protected) tmp]$ more export_simple_script_wrapper.sh.log.SCRIPT
RETURN CODE: Set initial Return Code - RC for this script.
1

ORACLE EXPort SUCCEEDED!: 0
0

[oracle@(protected) tmp]$ more exp.log.SCRIPT
...
EXP-00004: invalid username or password
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE.
1

ORACLE EXPort FAILED!: 1

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error
Handling & Exit Status?</TITLE>
</HEAD>
<BODY>


Guys, I'm stuck? 
 
I have two scripts; 
 - export_simple_script_wrapper.sh 
 - export_simple_script.sh 
 
 
export_simple_script.sh seems to work every time and in the logs shows the
correct "$RC" (=$?) every time for the right failure (or success). 
 
export_simple_script_wrapper.sh works, by calling export_simple_script.sh but
the log output and "if" logic proves that it is always getting
success "0" when export_simple_script.sh tells other wise. 
 
I have provided (I hope) enough log and script info below for your help in
finding my problem. 
 
Thanks in advance, 
 
Chris Marquez 
Oracle DBA 
 
 
++++++++++++++++++++++++++++++++ 
export_simple_script_wrapper.sh 
++++++++++++++++++++++++++++++++ 
 
################### 
# ERROR HANDLING & RETURN CODES 
################### 
# RETURN CODE: Set initial Return Code - RC for this script. 
RC=1 
echo 'RETURN CODE: Set initial Return Code - RC for this script.' >> $log
_file 2>&1 
echo $RC >> $log_file 
 
cleanup() 
{ 
        echo cleaning up 
        echo "RETURN CODE: $RC" 
} 
 
trap 'cleanup; exit $?' EXIT 
 
######################## 
# EXECUTE SCRIPT LOGIC: 1 
######################## 
typeset -i RC=`/bin/sh /tmp/export_simple_script.sh` 
if [[ $RC -ne 0 ]]; then 
        exit 
else 
        echo ' ' >> $log_file 
        echo 'ORACLE EXPort SUCCEEDED!: '$RC
>> $log_file 2>&1 
        echo $RC >> $log_file 
        echo ' ' >> $log_file 
fi 
 
# RETURN CODE: Show EXPort Return Code - RC: EXPort RETURN CODE. 
#RC=$? 
echo 'RETURN CODE: Show EXPort Return Code - RC: EXPort RETURN CODE.' >>
$log_file 2>&1 
echo $RC >> $log_file 
 
 
 
 
---THIS CODE WORKS EVERY TIME AND WHILE THE OUT IS ALWAYS THE CORRECT "RC
", 
"RC" IS NEVER PASSED CORRECTLY TO "export_simple_script_wrapper
.sh" 
 
++++++++++++++++++++++++++++++++ 
export_simple_script.sh 
++++++++++++++++++++++++++++++++ 
######################## 
# EXECUTE SCRIPT LOGIC: 1 
######################## 
 
exp <<EOFexp >> $log_file 2>&1  \ 
... 
exit 
EOFexp 
 
# RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE. 
RC=$? 
echo 'RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE.' >>
$log_file 2>&1 
echo $RC >> $log_file 
 
if [[ $RC -eq 1 ]]; then 
        echo ' ' >> $log_file 
        echo 'ORACLE EXPort FAILED!: '$RC
>> $log_file 2>&1 
        echo ' ' >> $log_file 
 
elif [[ $RC -eq 0 ]]; then 
        echo ' ' >> $log_file 
        echo 'ORACLE EXPort SUCCEEDED!: '$RC
>> $log_file 2>&1 
        echo ' ' >> $log_file 
 
else 
        echo ' ' >> $log_file 
        echo 'ORACLE EXPort Utility STOPPED!
: '$RC >> $log_file 2>&1 
        echo ' ' >> $log_file 
 
fi 
 
exit $RC 
 
 
 
 
++++++++++++++++++++++++++++++++ 
TWO EXAMPLE RUNS AND LOG OUTPUT 
++++++++++++++++++++++++++++++++ 
 
(#1.) 
---FORCE "export_simple_script.sh" - KILL EXP PROCESS 
[oracle@(protected) tmp]$ sh export_simple_script_wrapper.sh 
/tmp/export_simple_script.sh: line 75: 30047 Killed   exp USERID
=system/orcl9imanager FULL=Y ...<<EOFexp 
exit 
EOFexp 
cleaning up 
RETURN CODE: 0 
 
 
[oracle@(protected) tmp]$ more export_simple_script_wrapper.sh.log 
RETURN CODE: Set initial Return Code - RC for this script. 
1 
 
ORACLE EXPort SUCCEEDED!: 0 
0 
 
 
 
[oracle@(protected) tmp]$ more exp.log 
... 
. . exporting table          
   MON_ALERT_MESSAGES       1000 rows
exported 
. . exporting table          
             MON
_CONF 
RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE. 
137 
 
ORACLE EXPort Utility STOPPED!: 137 
 
 
 
 
(#2.) 
---FORCE "export_simple_script.sh" - BAD ORACLE PASSWORD 
 
[oracle@(protected) tmp]$ sh export_simple_script_wrapper.sh 
cleaning up 
RETURN CODE: 0 
 
 
[oracle@(protected) tmp]$ more export_simple_script_wrapper.sh.log.SCRIPT 
RETURN CODE: Set initial Return Code - RC for this script. 
1 
 
ORACLE EXPort SUCCEEDED!: 0 
0 
 
 
 
[oracle@(protected) tmp]$ more exp.log.SCRIPT 
... 
EXP-00004: invalid username or password 
EXP-00005: all allowable logon attempts failed 
EXP-00000: Export terminated unsuccessfully 
RETURN CODE: Set next Return Code - RC: ORACLE EXP RETURN CODE. 
1 
 
ORACLE EXPort FAILED!: 1 
 



</BODY>
</HTML>