shutdown scripts 
Author Message
 shutdown scripts
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



Tue, 05 Jun 2001 03:00:00 GMT
 shutdown scripts

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

Quote:

>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



Tue, 05 Jun 2001 03:00:00 GMT
 shutdown scripts

writes
Quote:
>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

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



Tue, 05 Jun 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Shutdown script?

2. Solaris 2.6 startup/shutdown scripts

3. HPUX startup/shutdown script

4. Anyone have auto DB shutdown script for NT?

5. startup/shutdown scripts

6. shutdown script for Oracle on NT

7. Startup/shutdown scripts for HP-UX-Oracle

8. linux shutdown script

9. Shutdown script on OSF for sybase

10. Sybase Startup/Shutdown scripts for HP-UX.

11. Shutdown script for linux


 
Powered by phpBB® Forum Software