Hi All;

        Does anyone have database shutdown scripts that will run on an NT
platform.  Any examples of using at to schedule theses shutdowns????

thanks in advance for any help here
eddie lufker

I've just set up our 7.3.3 database (3 instances) to autoshutdown for cold
backups.
I use AT (via the resource kit GUI) to run SHUTDOWN.BAT at a certain time
Monday - Friday.
The batch files produce logs of the process so you can see any errors.

xxxx    =    the relevent internal passwords for each instance
yyyy    =    instance identifiers
zzzz
wwww

SHUTDOWN.BAT

net stop oraclestartyyyy>> c:\log\shutdown.log
net stop oraclestartzzzz >> c:\log\shutdown.log
net stop oraclestartwwww >> c:\log\shutdown.log
net stop oracleserviceyyyy >> c:\log\shutdown.log
net stop oracleservicezzzz >> c:\log\shutdown.log
net stop oracleservicewwww >> c:\log\shutdown.log

SHUTDOWN.SQL

shutdown immediate;

shutdown immediate;

shutdown immediate;

To restart run
STARTUP.BAT
net start oraclestartyyyy > c:\log\startup.log
net start oraclestartzzzz>> c:\log\startup.log
net start oraclestartwwww >> c:\log\startup.log

--
To reply remove D1059

writes
Try something like -

c:\orant\bin\oradim73.exe -shutdown -sid ORCL -usrpwd oracle -shuttype
srvc,inst -shutmode i

Change ORCL for your own SID and oracle for your own internal password.

Put this line in a NT .com file and you should be able to schedule it
with AT commands. We run ours with an anti-virus scheduler, which works
fine.

HTH
--
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
Internet: www.nisoft.co.uk