sqlplus doesn't work in Crontab

Question

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked.

Answer 1

To run successfully in cron such job you need to set some variables like ORACLE_SID, ORACLE_HOME and so on. The samples way to do this is to make your script on this way:

source ~/.bashrc #or .bash_profile
/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

The source command will get the variables from your login and add them to the environment where you exec this task.

Answer 2

You have to set related env variables in the cron file before running the cron.

Run env or export, search for oracle relevant variables and copy them into the cronfile.

Additionally read the docs ;)