Re: oraenv and cron

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.

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
 asthe
> oracle user, it doesn't work; but if I have root run it in cron
 withsu -
> oracle -c script_name, it runs?Script

 fragment:#!/usr/kshORAENV_ASK=NO;export
> ORAENV_ASKORACLE_SID=PIG;export ORACLE_SID. /usr/lbin/oraenvyada,
 yada,
> yada...When oracle runs it, it appears as if none of the env
 variables are
> set. I may be nit-picking here, but I'd like Oracle to own its cron
> entries.Joseph-- Joseph Thvedtjthvedt_at_my-deja.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 18:49:09 CDT