RE: NT Scheduled Restart

Bruce,

What I tend to do is not shutdown the Oracle database using the shutdown.exe.
I execute a script fortnightly that first shuts down Oracle then calls the shutdown.exe to shutdown the box.

In this way the database is down before the shutdown.exe executes.

Similarly you can write a script to shutdown any application/db before kicking off shutdown.exe thus preventing any abnormal shutdown.

Luckily we use MKS Toolkit, I can write korn shell quite easily to do these routine tasks.

Regards
Suhen

Hi,

I also use this to reboot a server (not our Oracle one though) but beware of the "/C" switch - this may not do a clean shutdown of your applications / Oracle.
>From the help on NT4:

C              Forces running applications to close.
               ATTENTION: If you use the /C parameter NT ignores the
                          applications option to save data which may
                          have changed. You will see no File-Save dialog
                          box, because NT will force the application to
                          close. This will result in a loss of all data.
                          not previously saved !!!

This definitely results in SQL Server getting upset.

That said, why do you need to reboot - for example our NT Oracle server (81511, NT 4 SP6a) has been up for 238 days?

Regards,
Bruce

-----Original Message-----
Sent: Wednesday, 23 May 2001 5:50
To: Multiple recipients of list ORACLE-L

> Rajesh Dayal wrote:
>
> Hi all,
> I am looking for a utility (preferably freeware), which
> can perform a scheduled shutdown of NT 4.0 server. This I
> need because of inconsistent behavior of NT for Oracle
> Services. I want to do a scheduled restart after every night
> backup(scheduled).
> Appreciate your inputs and suggestions.
>
> TIA,
> Rajesh

NT Resource Kit supports the shutdown command. use it.

for W2K: (don't have any NT4 boxen here)

shutdown /L /R /C

is good.

/L - local
/R - reboot
/C - close apps.

hth,

Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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).