Shell Programming and Scripting

Can you show us waht is in the scripts:

/export/home/inrvgo/thelak/SQL.sh
/export/home/inrvgo/thelak/China.sh


And your Oracle environment.
The output from this command sequence when executed interactively from an account where the script works:

Code:

set | grep "ORA"
set | grep "PATH" | grep -v "MANPATH"

HI methyl,
Its fine working with your solution thanks

---------- Post updated 10-09-10 at 08:14 AM ---------- Previous update was 10-08-10 at 10:03 AM ----------

Hi,
As i mentioned above my cron job is failing when i run as a batch in specific interval @ 30 8 * * * /export/home/inrvgo/thelak/China.sh

But if i tried the same batch by changing the time stamp in crontab its working
@24 18 * * * /export/home/inrvgo/thelak/China.sh

its simply calling two child scripts
here am giving the decode of the file
#!/bin/ksh
rm -f *.txt
#/home/insivs/sql/thilak/SQL.sh
/export/home/inrvgo/thelak/SQL.sh
/export/home/inrvgo/thelak/disk.sh >> Daily_Check`date +"%m-%d-%Y-%H"`.txt
< /home/insivs/sql/thilak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
mailx -s "Daily Monitoring Check " thelak.kumar@abc.com, "in.finacle.china.support@abc.com","G....Kumar@abc.com" < /export/home/inrvgo/thelak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
----------------------------------------------------------------------

when i tried this at 30 8 * * * /export/home/inrvgo/thelak/China.sh
it displays error
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.
A file or directory in the path name does not exist.
/export/home/inrvgo/thelak/China.sh[7]: /export/home/inrvgo/thelak/Daily_Check10-09-2010-08.txt: 0403-016 Cannot find or open the file.


when it get success it displays like this

produced the following output:
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.

Please help on this