UNIX for Dummies Questions & Answers

Hi ,

I am running Oracle 8.1.7 on HP-UX B.11.00. Recently I have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out .

However I receive the error
SP2-0310: unable to open file "/apps/prod/sql/xxxx.sql " .

I exeuted the same sqlplus command thru prompt, it works fine, problem occurs only from shell Script. Also I verified the permission. Everthing is fine.

Please let me know what may be the problem?

--ananth

hey can u give us the part of your unix scripts where u are calling sqlplus -s

Hi,

Thanks for your reply.
I am using the following script. GetJobDetails is a script in unix. It assigns the value for JobCommand, $JobDesc and JobType. Then i am passing this sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" command in IF loop.
The partial script is

==================================================

GetJobDetails

case $JobType
in
SQL)
InsertLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'START'
if ( PrereqsCheck ) then
print "$Step - $JobCommand > $LogString 2>$ErrorString"
if (time sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" ) then
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'COMPLETE' 0
else
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'HALTED' 0
NotifyOperator 1 "$JobDesc" URGENT
fi
CompressInput
CompressOutput
fi
;;
esac

---------------------------------------------------

Thanks in Advance.

Regards,
Ananth P