Re: Shuttung Down DB from Cron

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 -