Thanx. A lot of development work is going on and I need a daily report on the changes made in the packages. Recompiled Invalid objects suppliment my report. Ciao, CSW
-----Original Message----- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:58 AM To: Multiple recipients of list ORACLE-L 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" <[EMAIL PROTECTED]> 22/03/2002 04:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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/$[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- 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).