Shutting down Oracle overnight...

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.