Re: automating shutdown,startup??

In article <345DCDBF.A68DA09E_at_gatwick.geco-prakla.slb.com> Ian Cary wrote:
> Jason Berryhill wrote:
>
> > I would like to be able to automate shutdown, backup, and restart of my
> > db from witin a cron job.
> >

[stuff about using svrmgrl to do this snipped for brevity]

> Also when writing the cron script you must remember to explicitly declare
> all your environment variables e.g. ORACLE_SID, ORACLE_HOME, PATH as the
> cron routine does not inherit these values from the submitting user.

This is why I prefer to have all crons run as root with the command running as an su - to the required user. It gets the .profile run and therefore the environment for the user. My SysAdmin also likes it this way because he can  more easily see what job will run when. Of course, it means that the profile must be set up in such a way that it will handle a non-interactive login but this is not too difficult.

Do other people dot it this way? People I meet just automatically go for the use of the users crontab and leave it that. I get strange looks when I suggest the root approach.

Regards

Ian Received on Mon Nov 03 1997 - 00:00:00 CST