oraenv and cron

From: Joseph T <jthvedt_at_my-deja.com>
Date: Wed, 27 Sep 2000 20:25:01 GMT
Message-ID: <8qtl2j$hqo$1@nnrp1.deja.com>

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. Received on Wed Sep 27 2000 - 15:25:01 CDT