RE: Cronjob misbehaving

From: Hallas John <John.Hallas_at_O2.COM>
Date: Fri, 22 Mar 2002 01:03:24 -0800
Message-ID: <F001.00430935.20020322010324@fatcity.com>

It looks as if your ORACLE_HOME is not being set up. Try either or both of the following

1. Amend your cron job to look like the following (I assume you are running this as user oracle)

0 5 * * * su - oracle 'usr/scripts/recompile.sh' > /ops/scripts/recompile.log 2>&1

Otherwise set the environment up in the script

#!/bin/ksh

export ORACLE_SID=<your sid>
export ORACLE_BASE=<your base>
export ORACLE_TERM=vt100
export ORACLE_HOME=<your home>

export PATH=$PATH:$ORACLE_HOME/bin

Then the script

HTH John

-----Original Message-----
Sent: 22 March 2002 08:18
To: Multiple recipients of list ORACLE-L

Hi all,
Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob

-------------Cron Entry
0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1

-------------recompile.sh
#!/bin/ksh

## Program name : recompile.sh
## Purpose : Recompile Invalid Database Objects for specified Shema in
FLAG
## Author : C.S Waibale Simon
## Date written : 2002-03-19

#for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
#j:=1
#$i=${i:-$(crypt flag < passwds |awk '{print $j}')
#done

SQLPLUS=/ops/product/817/bin/sqlplus
#Do not export the password variables !

FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $2}')}
WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} echo "Recompiling Invalid Database Objects in the FLAG instance"
#This can be sustitued with generic code

$SQLPLUS flag_calls/$CALLS_PASS_at_flag.mtn.co.ug @/ops/rom/recompile.sql
$SQLPLUS flag/$FLAGPASS_at_flag.mtn.co.ug @/ops/rom/recompile.sql
$SQLPLUS flag_wh/$WHPASS_at_flag.mtn.co.ug @/ops/rom/recompile.sql

---------recompile.log
Recompiling Invalid Database Objects in the FLAG instance Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus

What could be broken ??
The script runs correctly from comand prompt.

---

+---------------------------------------------------+
C.S Waibale Simon
MTN-Uganda, 8th Floor UDB Building
Cell: +256 77-212655,http://mtn.co.ug
+---------------------------------------------------+ 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Simon Waibale
  INET: waibals_at_mtn.co.ug

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas John
  INET: John.Hallas_at_o2.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Mar 22 2002 - 03:03:24 CST