Set your Oracle environment as the first thing in the cron job (typically by setting ORACLE_SID and calling oraenv)
hth connor --- Simon Waibale <[EMAIL PROTECTED]> wrote: > 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/$[EMAIL PROTECTED] > @/ops/rom/recompile.sql > $SQLPLUS flag/$[EMAIL PROTECTED] > @/ops/rom/recompile.sql > $SQLPLUS flag_wh/$[EMAIL PROTECTED] > @/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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).