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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
