RE: Oracle Shutdown/Startup Scripts for Windows 2000 or NT 4.0

This is a multi-part message in MIME format.

------=_NextPart_000_0026_01C02D5A.662940A0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Debra,

simply call shutdown.bat at a specific time using the Windows AT command. It will then call shut.sql to shutdown the database.

hth,
Helmut

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Debra
> Ruggerie
> Sent: Tuesday, October 03, 2000 05:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Shutdown/Startup Scripts for Windows 2000 or NT 4.0
>
>
> We recently acquired Oracle 8.1.6 and are running it on a Windows 2000
> server. My Oracle experience is with Unix. Would someone have
> shutdown and
> startup scripts they would be willing to share for the Windows 2000 or NT
> 4.0 environment?
>
> Thanks,
>
> Debbie Ruggerie
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Debra Ruggerie
> INET: druggerie_at_ugf.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

------=_NextPart_000_0026_01C02D5A.662940A0 Content-Type: application/octet-stream;

        name="shut.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

        filename="shut.sql"

REM Shut.sql

REM ==================== 

shutdown immediate
exit

------=_NextPart_000_0026_01C02D5A.662940A0 Content-Type: application/octet-stream;

        name="shutdown.bat"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

        filename="shutdown.bat"

REM shutdown database

sqlplus internal/login19 @c:\oracle\admin\vivonet\backup\shut.sql

REM after db is shutdown cleanly, stop Oracle service from control panel NET STOP OracleServiceVIVONET
NET STOP OracleOraHome81TNSListener Received on Tue Oct 03 2000 - 18:53:05 CDT