Re: cron and ORACLE_HOME env

do you << the user running cron>>have all your oracle environment variables set up in your login or .profile
depending on what shell your running either export $ORACLE_HOME or set $ORACLE_HOME within the first commands in the shell script

mmustafa_at_my-deja.com wrote:

> 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