Re: oraenv and cron

In article <8qu11j$s29$1_at_nnrp1.deja.com>,   kal121_at_my-deja.com wrote:
> All the scripts I run are from Oracle's cron file. Each shell script
> that runs explicitly sources Oracle's .bash_profile. Your config file
> may be different depending on which shell you are using.
>

I can't run my usual .profile, since it uses the interactive features of oraenv to deal with multiple $ORACLE_SIDs. Presumably using oraenv with ORAENV_ASK=NO is the part of my .profile that I need, but it just doesn't work unless I su - oracle.

Oh, and I apologize for the atrocious formatting of the original question. Somewhere between deja.com's preview and Netscape 6.2, it was totally trashed.

> In article <8qtl2j$hqo$1_at_nnrp1.deja.com>,
> Joseph T <jthvedt_at_my-deja.com> wrote:
> > Why is it that if I run a shell script containing oraenv from cron
> > as the
> > oracle user, it doesn't work; but if I have root run it in cron
> > with su - oracle -c script_name, it runs?
[edit]

--
Joseph Thvedt
jthvedt_at_my-deja.com


Sent via Deja.com http://www.deja.com/
Before you buy.