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
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)
t; <[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
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
>
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' >
lt;[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subjec
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
