Re: Shuttung Down DB from Cron

Jared Hecker wrote:

> Here's what to do:
>
> make a hidden file with the internal password
>
> write a script that:
>
> makes an environmental variable that loads the password from the
> hidden
> file
>
> run svrmgrl and calls an SQL script that shuts down the database
>
> cron it.
>
> hth -
>
> Regards,
> jh
>

Better still, just 'su - oracle' the script in cron - that's what I do... No need to hide any passwords, etc., etc., etc.

Steve Phelan. Received on Thu Jul 10 1997 - 00:00:00 CDT