RE: Error while running export backup shell script

I presume that the "mknod" does NOT report an error and actually does create a pipe device ?

Let's see the other errors
LRM-00112 multiple values not allowed for parameter 'string' Cause: An attempt was made to specify multiple values for a parameter which can take only one value.
Action: Do not specify more than one value for this parameter.

EXP-00019 failed to process parameters, type 'EXP HELP=Y' for help Cause: Invalid command-line parameters were specified. Action: Check the online help screen for the set of valid parameters, then retry.

Have you tried running the functions in the do_export() in a seperate command file
to see that the mknod and the exp commands run properly ?

Note that if you are still getting messages like Message 112 not found; No message file for product=ORACORE, facility=LRM and
Message 19 not found; No message file for product=RDBMS, facility=EXP it DOES mean that your ORACLE_HOME is not getting set in the environment.

Which shell is the script running in ? Are you sure that the "export ORATAB=/var/opt/oracle/oratab" and other lines are actually exporting of the variables ? Else try ORATAB=/var/opt/oracle/oratab; export ORATAB and so on

Hemant
At 04:23 PM 21-03-03 +0530, you wrote:
>Hi Hemanth,
>
> Thanks for your mail. Yes, I have included the path for "mknod".
>The entries in the ORATAB file are as follows:
>
> *:/data/oracle9i/product/9.0.1:N
> DANZAS:/oracle8i/product/8.1.6:N
> BEMES:/oracle8i/product/8.1.6:N
> VERIO:/data/oracle9i/product/9.0.1:N
> FANTA:/oracle8i/product/8.1.6:N
> LSYRS:/oracle8i/product/8.1.6:N
>
> Still the script is not running properly. Should I change anything
>in the script?
>
>Thanks and Regards,
>
>Ranganath
>
> > -----Original Message-----
> > From: Hemant K Chitale [SMTP:hkchital_at_singnet.com.sg]
> > Sent: Friday, March 21, 2003 3:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Error while running export backup shell script
> >
> >
> > The "mknod" command isn't in the path. Either
> > setup the path in the script or explicitly
> > specify the path.
> >
> > I don't think that the ORACLE_HOME is getting set
> > correctly in your derive_oracle_paths function.
> > Check the oratab file.
> > Hemant
> > --- "Krishnaswamy, Ranganath" <Ranganath.Krishnaswamy_at_blr.hpsglobal.com>
> > wrote:
> >
> > > 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
> > > error. Thank you.
> > >
> >
> >
> >
> > Hemant K Chitale
> > http://hkchital.tripod.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hemant K Chitale
> > INET: hkchital_at_singnet.com.sg
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>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 - 09:46:39 CST