Re: Shutting down Oracle overnight...

sd345_at_city.ac.uk (Michael Collier) writes:

> Here at City we perform a backup of the academic Oracle system by
> doing a shutdown every night and performing a dump.
>
> However if people leave Oracle processes running overnight the
> shutdown doesn't finish and the backup doesn't get done.
>
> So what I would like to do is a shutdown immediate each night.
>
> I have tried (in the dump script)...
>
> sqldba shutdown immediate
> sqldba "shutdown immediate"
> sqldba 'shutdown immediate'
>
> ...none of which do the trick. All that it ever seems to want to do is
> a plain old sqldba shutdown.
>
> Can anyone shed any light on this?
>
> Michael.
> --
> Michael Collier (Programmer) The Computer Unit,
> Email: M.P.Collier_at_uk.ac.city The City University,
> Tel: 071 477-8000 x3769 London,
> Fax: 071 477-8565 EC1V 0HB.

Try putting "shutdown immediate;" (without quotes) into a file and saying
sqldba < yourfile

--
"See your System Administrator?" I *AM* the #%_at_!?& System Administrator!

INTERNET: tumidity_at_netlink.cts.com (Joel Garry) 
UUCP:  ...!ryptyde!netlink!tumidity