Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error while running export backup shell script

Re: Error while running export backup shell script

From: Darrell Landrum <dlandrum_at_zalecorp.com>
Date: Fri, 21 Mar 2003 03:19:13 -0600
Message-Id: <24738.322684@fatcity.com>


Hi,

Looks like one or more environment issues. First, make sure that mknod is in your path or go ahead and enter the full path to it in the script ( /usr/sbin/mknod on my local HP system, looks like you might be on Sun, though ). Next, make sure your export command is all on one line. Instead of ..
exp system/${SYSTEM_PWD} buffer=10485760 direct=y log=${EXP_LOG} file =${EXP_PIPE} full=y consistent=y 2>/dev/null

use..
exp system/${SYSTEM_PWD} buffer=10485760 direct=y log=${EXP_LOG} file=${EXP_PIPE} full=y consistent=y 2>/dev/null

After that, your script worked fine for me. Good luck!

>>> Ranganath.Krishnaswamy_at_blr.hpsglobal.com 03/21/03 01:43AM >>> Hi List,

        I have got a shell script for taking full export backup which I am attaching with this mail as .sql file as I cannot send .sh file as file attachments. I am getting the following error when I run the script in full_exp_20030321_1309_job.log:

###########################################################################
#Starting fullexportlsyrs.sh at Fri Mar 21 13:09:41 GMT 2003
#

fullexportlsyrs.sh[3]: mknod: not found fullexportlsyrs.sh[4]:
/export/home/ranganat/backups/full_exp_20030321_1309_pipe : cannot open
LRM-00112: Message 112 not found; No message file for product=ORACORE, facility=
LRM EXP-00019: Message 19 not found; No message file for product=RDBMS, facility=EXP
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP/
export/home/ranganat/backups/full_exp_20030321_1309_pipe: No such file or direct
ory
#
#Job run time was: 0 hours, 0 minutes, 0 seconds
#
#Ending fullexportlsyrs.sh at Fri Mar 21 13:09:41 GMT 2003 with an exit
status o
f 127

############################################################################
#

What should I do to eliminate the above errors and run the scripts successfully?

Any help in this regard is very much appreciated

Thanks and Regards,

Ranganath

 <<fullexportlsyrs.sql>>

WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in Received on Fri Mar 21 2003 - 03:19:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US