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
>
> Renato Brazioli (brazioli_at_sodalia.it) wrote:
> : Roy Coleman wrote:
> : >
> : > I'm trying to shut down the database from within cron so I can perform a
> : > full backup with the database down. When I kick off the DBSHUT command
> : > from cron it errors out. I just upgraded to Sun Solaris 2.5.1 and Oracle
> : ^^^^^^^^^^^^
 

> : how ? Please give more details !
 

> : Have you checked if your environment is setup correctly during cron
> : execution ?
 

> : Renato
> : --
> : ______________________________________________________________________________
> : Renato Brazioli Sodalia SpA e-mail: brazioli_at_sodalia.it
> : Via Valentina Zambra,1 voice: +39(461)316.154
> : (direct)
> : I-38100 Trento fax: +39(461)316.401
> : ITALY
> : http://www.geocities.com/Paris/4385
>
> --
> Jared Hecker - CODBA | ** HWA, Inc. ** Oracle and Sybase
> jared_at_hwai.com | database architecture and administration
> 76276.740_at_compuserve.com | - serving the NYC/NJ region -

Email your shutdown script here. Who runs this cron? Root? What errors you getting?
Halina Received on Thu Jul 10 1997 - 00:00:00 CDT