Re: cron and ORACLE_HOME env

the job is being run by a regular user . I am cronning the job under my name ? The problem that crom mails me with is ORACLE_HOME not set, and as I said, there is a whole file with things like ORACLE_HOME = /local/oracle/app/oracle/product/7.3.2 export ORACLE_HOME
and bunch of other things

Any ideas , how to set up cron's environment

In article <397DB59C.BF4B0D0B_at_hotmail.com>,   wildpony <z1wildpony_at_hotmail.com> wrote:
> who is running cron root ???, is so then su -oracle to change to the
> oracle user and get all the oracle user environments or run set up
 cron
> to be run as oracle
>
> mmustafa_at_my-deja.com wrote:
>
> > This question has probably been asked before, but I didn't find a
> > viable solution, after reading many of them.
> > Basic Problem : Job runs fine when run from command line, but fails
> > when cronned.
> > Attempts : Set up ORACLE_HOME , ORACLE_SID .... etc .... etc in a
> > configuration file and put that file at the top of the crontab file.
> > Complains : ORACLE_HOME not set !
> >
> > HELP !!!
> >
> > Thanks
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 25 2000 - 00:00:00 CDT