Re: Automating shutdowns

From: Patrick Bogers <p.bogers_at_scope-mt.nl>
Date: 1998/02/10
Message-ID: <6bpnv1$9qe@news.euro.net>#1/1

Brian Camper wrote in message <01bd3285$a86173c0$03e057cf_at_brianc>...
>Hello,
>
>I am fairly new at Oracle, and I am wondering how/if you can create a batch
>file to shutdown a database instance on a Windows NT Server running Oracle
>7.3.3.0.0. I have found examples on how to do this in Unix, but I can not
>do the same procedures on a NT 4.0 environment. Let me know if anyone else
>has tried to do this.
>
>Thanks in advance,
>
>Brian Camper
>
>brianc_at_cmhc.com

Try creating a cmd-file with the following text:

set oracle_sid=<SID>

<ORACLE_HOME>\bin\svrmgr23 @shutdown.sql

net stop oracleservice<SID>

usually <ORACLE_HOME> is C:\ORANT
In the shutdown.sql script put the following;

    spool shutdown.log (if a log-file of shutdown is required)     connect internal
    shutdown immediate
    exit

Patrick Received on Tue Feb 10 1998 - 00:00:00 CST