Oracle Database Discussions

Hi,

I am sorry I have no idea, whether this is the right place to post this thread. One of my job is not working through crontab. Where as I am able to run it manually and getting the desired file at the desired location with desired result. Here are the details.

Entry in the Crontab :-

48 17 * * * /u01/app/oracle/rman/scripts/Db_health_check_daily.sh

The code of the shell script:-

#!/usr/bin/ksh
ORATAB=/var/opt/oracle/oratab
ORACLE_HOME=/u01/app/oracle/product/8.1.7.4
export ORACLE_HOME
TNS_ADMIN=/var/opt/oracle/network/admin
ORACLE_SID=dcddev1
export ORACLE_SID ORACLE_HOME TNS_ADMIN ORATAB
$ORACLE_HOME/bin/sqlplus -s "/" <<EOF
@/u01/app/oracle/rman/scripts/Db_health_check_daily.sql
EOF

Permissions are as follow:-
-rwxrwxrwx 1 oracle dba 313 Aug 13 17:32 Db_health_check_daily.sh

Please help me in this.

Thanks and Regards
Harpreet Singh