Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: automating shutdown,startup??
Ian, I'm in total agreement with you. I've been utilizing root's crontab for
years to start and
stop my Oracle databases. In addition, using root's su - facilitates
controlling any application processes owned by other users that need to be
shutdown/started before/after the database(s).
Cheers,
Dennis.
Ian Dixon wrote:
> 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 Wed Nov 05 1997 - 00:00:00 CST