Oracle-L: Re: Cronjob misbehaving

From: <hemantchitale_at_charteredsemi.com>
Date: Fri, 22 Mar 2002 00:58:19 -0800
Message-ID: <F001.0043091B.20020322005819@fatcity.com>

Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH.

Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated
every day ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

"Simon Waibale" <waibals_at_mtn.co.ug> 22/03/2002 04:18 PM Sent by: root_at_fatcity.com

Please respond to ORACLE-L

                                                                                                               
             To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                   
             cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)                                             
             Subject: Cronjob misbehaving

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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: hemantchitale_at_charteredsemi.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 - 02:58:19 CST