Cron job problem

[SUR1805]

I am using cron( in RHEL 5 machine) to schedule the automatic backup of database.
I created a user cronjob through crontab -e for oracle user which is shown inside /var/spool/cron/ with oracle name. the content of cronjob is given below
--------------------------------------------
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=""
#HOME=/home/oracle/
01 20 * * * * /data1/bkp.sh > /tmp/orasql.txt 2>&1
--------------------------------------------

The problem is instead of running this job through oracle user system is running the cron through root user which is not getting the sqlplus command inside the script.
Now how to change the default user.
The content of bkp.sh ---
---------------------------------------------
sqlplus -S '/ as sysdba' <<-ENDSQL
set pages 80
set feedback off
set head off
spool /data1/sysdata/files2backup.txt
select name from v\$datafile;
select name from v\$controlfile;
select member from v\$logfile;
select name from v\$tempfile;
spool off
exit
ENDSQL
------------------------------------------

Early reply will be awaited.
Thanks.

[Rubberman]

Read your cron man pages. I notice that you have 6 date/time fields defined. There should only be five, so the last * might be confusing cron.

[SUR1805]

Sorry by mistake i have given this here in post only in cron there is 5 fields only
. but that is not an issue the thing is that when i created the cron for oracle user why it is running with root user. this is the reason it is not able to run sqlplus command.
Is there any way to find the reason?

[Rubberman]

It runs with the user id in the cron script. Look at /var/spool/cron/oracle and see who the owner for that file - ls -l /var/spool/cron/oracle should return a string something like this: -rw------- 1 oracle root 70 Apr 28 08:54 /var/spool/cron/oracle
If it shows root as the owner, then possibly the crontab program has been setuid root. That would be the next thing to look at in this case.

[SUR1805]

ys. this also i have checked the owner is oracle only.

[Rubberman]

ys. this also i have checked the owner is oracle only.

I don't know what the problem is then. On my system it runs with the user id.

[dskonnur]

Login as "su" and then schedule your tasks .