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:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 error. Thank you.
Hemant K Chitale My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
