RE: Crontabs and Oracle

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Wed, 28 Nov 2001 04:03:50 -0800
Message-ID: <F001.003CEB6D.20011128034154@fatcity.com>

I don't know if it is relevant but on Compaq Tru64 we have to su - oracle even within the oracle cron so a sample entry looks looks as follows.

10 19 * * * su - oracle -c '/usr/local/bin/tidy_listener_log.sh' > etc etc

Your message_is mentions Sun in which case I am sure this does not need to be done (nor HP). Hope it is useful, probably not

John

-----Original Message-----
From: Thomas, Kevin [mailto:Kevin.Thomas_at_calanais.com] Sent: 28 November 2001 11:00
To: Multiple recipients of list ORACLE-L Subject: Crontabs and Oracle

Guys,

I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command

$ host_startup.sh

However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. Received on Wed Nov 28 2001 - 06:03:50 CST