RE: Cronjob misbehaving
Hi James,Connor, Hallas, Hemant Receive my heartfelt and sincere vote of thanx to you all for the brotherly guidance - I solved this and promise to pay back by helping someone else out there in turn. Simon -Original Message- Sent: Saturday, March 23, 2002 7:33 AM To: Multiple recipients of list ORACLE-L Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a) Make sure your script sources the user's .profile or, better yet: b) Adopt a standard by which any script you may want to possibly submit through cron defines the important environment settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.) -- James Simon Waibale 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.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.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). -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA "The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow 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
Re: Cronjob misbehaving
Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a) Make sure your script sources the user's .profile or, better yet: b) Adopt a standard by which any script you may want to possibly submit through cron defines the important environment settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.) -- James Simon Waibale 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.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.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). -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA "The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow 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).
RE: Cronjob misbehaving
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.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.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).
Re: Cronjob misbehaving
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.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.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).
RE: Cronjob misbehaving
Title: RE: Cronjob misbehaving 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= export ORACLE_BASE= export ORACLE_TERM=vt100 export ORACLE_HOME= export PATH=$PATH:$ORACLE_HOME/bin Then the script HTH John -Original Message- From: Simon Waibale [mailto:[EMAIL PROTECTED]] Sent: 22 March 2002 08:18 To: Multiple recipients of list ORACLE-L 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.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.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). = 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. =
Re: Cronjob misbehaving
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.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.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).
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.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.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).