Unix script Problem with crontab

UNIX Solaris
1

Hi Experts,

Am facing some problems with script (Sun solaris 9). My script (sqlplus.sh)looks like this. . .

...............................................
set 'date'
dd=$3
export dd
mon=$2
export mon
yyyy=$6
export yyyy
cd /oracle/P47/saparch
LOG_FILE=/oracle/P47/saparch/archive_today_$yyyy$mon$dd.log
echo "*******************************************************************">> $LOG_FILE
date >> $LOG_FILE

sqlplus "/as sysdba"<< EOF >> $LOG_FILE
set serveroutput on ;
set time on ;
recover automatic standby database;
CANCEL
exit
EOF
echo "Finish applying archives in SAP DR site..." >> $LOG_FILE

echo " ----------------------------------------------------------">> $LOG_FILE

echo "End SAP DR script " >> $LOG_FILE
echo "=========================================================" >> $LOG_FILE

mailx -s "LOG - SAP DR applying archives $dd$mm$yy..." vrjalli@xyz.com < $LOG_FILE

...............................................................................................

My problems are

  1. When I run manually (with command: sh sqlplus.sh) it is working fine. But when i schedule in cron it is not working.
  2. Mails are not coming.
  3. Log file is coming without date stamp.(archive_today_.log)

Please help. . .

rgds

2

When you say its not working what is the error received ?

modify your cron entry to

script > logfile 2>&1

and instead of using just sqlplus
use the absolute path of the sqlplus as user's profile is not implicitly loaded to cron unless done explicitly

3

Hi matrixmadhan,

Thanks for ur reply!!!!

my script parh is: /oracle/SID/saparch/sqlplus.sh

and cron entry is:
30 10,13,15,17,19,21 * * * /oracle/P47/saparch/sqlplus.sh

and I hv given 777 permisions to sqlplus.sh file.

rgds

4

Ok. After using absolute pathname what is cron saying after executing ?

Post the error message if there are any such !

5

Am not getting any error simply it is not executing. . . . .

my script parh is: /oracle/P47/saparch/sqlplus.sh
and cron entry is:
30 10,13,15,17,19,21 * * * /oracle/P47/saparch/sqlplus.sh

but when my pwd is: /oracle/P47/saparch
it is working with command: sh sqlplus.sh

rgds

6

Hi Matrixmadhan,

Actually when i try ps -ef | grep

I recd message that there is a mail in /var/mail/root and the contents are as below

Date: Tue, 15 Jan 2008 17:31:00 +0530 (IST)
From: Super-User <root@ttmlpunesun>
Message-Id: <200801151201.m0FC10GB024886@ttmlpunesun>
To: root@ttmlpunesun
Subject: Output from "cron" command
MIME-Version: 1.0
Content-Type: text/plain
Content-Length: 148

Your "cron" job on ttmlpunesun
/oracle/P47/saparch/sqlplus.sh

produced the following output:

/oracle/P47/saparch/sqlplus.sh: sqlplus: not found
.................................................................................

rgds

7

What the cron job mail is saying is that your script is not finding the sqlplus execuble

You need to modify the line

sqlplus "/as sysdba"

to include the full pathname to sqlplus.

It is always good practice to include full pathnames in all shell scripts invoked via cron.

8

Also what is the shebang line in the script ( the first line ) ?

9

Some hints:

  1. When you run from crontab then environment from your ~/.profile is not inherited. Thus the script does not know where to find executables mailx,sqlplus, etc. (as $PATH is not set to what you might want)
  2. Try to avoid using fixed positions of the arguments. You should try to analyze parameters usually and parse them in some loop.
  3. try to enclose parameters in apostrophes. imagine something like this:
    LOG_FILE='/tmp/some strange path with spaces and $ sign'
    /oracle/P47/saparch/sqlplus.sh 'first param' 2 3 4 5 6 7 8