RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?
From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
To: <cichomitiko@xxxxxxxxx>, "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 1 Sep 2005 16:01:54 -0600
You're right. Damn, how did miss that?
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Radoulov, Dimitre
Sent: Thursday, September 01, 2005 3:31 PM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: Re: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error
Handling & Exit Status?
It's the RC's variable value(not the return code, but the entire command
output). Look at the second one ...
a)
$ export_simple_script.sh > /dev/null 2>&1 ; RC=$?; echo $RC
1
b)
$ RC=`export_simple_script.sh` > /dev/null 2>&1 ; echo $RC
Export: Release 9.0.1.5.0 - Production on Thu Sep 1 23:28:21 2005 (c) Copyright
2001 Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 1034
encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does
not exist SVR4 Error: 2: No such file or directory 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
Cheers,
Dimitre Radoulov
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.
