UNIX for Dummies Questions & Answers

Hi
Can some one please look this over for errors? I am trying to run it on cron but it doesn't seem to want to run.

The names have been changed to dummies.

Code:

#!/sh/bash
 
#script to keep location on line chunking.  it checks every four hours by #cron to see if it is working.
 
#if it is not running then start it up again.
 
export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOSTNAME=redhatora03
export ORACLE_SID=sid_name
 
export  PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/home/oracle/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
 
cd /home/oracle/monitor
 
export CURRTIME='date+%m/%d/%y:%H:%M:%s'
echo ${CURRTIME}
 
if  $? = 0  then   #this checks the return of the last executed statment.
null                   #0  for "ok" and a non zero number for an error.
 
else
 
nohup sqlplus schema_owner/passwd@sid  @/home/oracle/chunker_loc/chunker.sql  >  sidcronchunk.out &
 
fi

====
end of script

Thanks in advance for your help in this matter.

regards,

bdby

Is cron mailing you any errors? If cron can't tell you the error messages, try trapping them with exec 2> /tmp/myerr at the beginning of your code. If /tmp/myerr doesn't appear at all, your cron line isn't being run at all. Otherwise, its contents may be helpful.

Hi

Thanks for your help.

I am new at this scripting and will check out your suggestion. I will let you know what is going on.

al

The very first line (the Shebang line) is wrong.
Probably should be:

Code:

#!/bin/bash

The date command will not execute because it is in single quotes. Also it contains syntax errors.
Maybe you meant:

Code:

export CURRTIME=$(date '+%m/%d/%y:%H:%M:%s')
echo "${CURRTIME}"

However, outputting text into space just causes cron to trigger an email containig the text, unless you somehow redirect the output to a logfile.

duh

Just call me homer !!!

... and the "if" statement contains basic syntax errors. However the entire "if" statement appears to be pointless because it will just check the reply from the preceding "echo" command which will always be value zero.
I would remove the "if" statement completely and just invoke sqlplus with its full path.

Code:

${ORACLE_HOME}/bin/sqlplus

Hi

The reasoning I am trying to corral this is as follows.

We have two databases one here and the other in Europe replicating. There is one large table over 8 mil rows that has fallen way behind and because of the connectivity issues doing inserts directly into a staging table seems easier.

Anyway every day I kick off an insert statement but can't continually monitor the progress. What I wanted to do thru the cron was determine if that statement was still running every 4 hours. If it was running then do nothing. If it wasn't running then kick the job off again.

This is what I was trying to accomplish with this script. I am new at this and reading every night about this scripting.

This script would make my life easier at work because I actually have 3 other locations that needs this support.

Any help would be appreciated.

Regards

Al