Re: Unix backup script problem

keith_at_loony-toons.tamu.edu (Keith A. Marrocco) writes:

>Oracle *is* up and running when the script gets these messages. Can anybody
>tell me why the script works when we enter the commands manually but croaks
>when we have cron submit it? I can post the script itself if it is necessary.

Sounds like the cron job doesn't have the Oracle environment variables all defined correctly. My cron job to do similar functions runs as root and uses:

      su - oracle7 -c /home/oracle7/bin/dbstart &

to start the database back up again. Of course oracle7 is the oracle dba account and properly initializes itself.

BTW, how do you (or others reading this post) handle checking for users that are still logged on? If you do a 'normal' shutdown and someone forgot to log off, the shutdown will hang waiting for the user to log off.

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)