Hi All,
I have a script while manually running it creates a file dbcheck.log and check the value in it.But while same script ran through cron the script is creating a 0 byte file but not able to insert data.

Here is my code:

db_check=/home/dmidev/appl/scripts/dbcheck.log
for i in 1 2 3 4 5 6 7 8 9 10
do
#Check_RibDB_Up
`sqlplus -s user/passwd@ora_sid << EOF > $db_check

$SQL_SETS
$SQL_CNT
EOF`
egrep 'ERROR | ORA' $db_check #case $TR in
if(($?==0))
then
echo "$i time and Data Base is down and script is going for asleep for 1 hour" >> $oraerr
mail_send
sleep 3600
continue
else
echo "Data base is up at $i th check and weekly.ksh starts executing" >> $oraerr
/home/dmidev/appl/scripts/megh1.ksh
exit
fi
done



Regards
Megh

Does the user that the cronjob runs under the same as "dmidev"? Is the PATH environment variable at login-time set properly to run sqlplus? Just in case, copy the PATH variable into the script:
Copy the output and insert at the top of the script.

Check for

ORACLE_HOME
ORACLE_SID

as well