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

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 1 Sep 2005 16:01:54 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B87340F@fiji.arraybp.com>

You're right. Damn, how did miss that?  

---

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Radoulov, Dimitre Sent: Thursday, September 01, 2005 3:31 PM To: Marquez, Chris; oracle-l_at_freelists.org 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 01 2005 - 17:04:58 CDT