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.

Other related posts: