Re: OracleServiceSID - shutdown question

Hi miriam
1 A proper shutdown abort would reflect in the alert log file and this shutdown doesn't. The only thing you see is the crash recovery. This brings me to the assumption that stopping a service simply kills all threads associated with them.
2 Oracle decided to implement their software as an NT-service and NT services work this way. Call them both accomplishes in this crime. Or better still, while Oracle (at least this is known fact about Larry) definitely dislikes NT, they simply can't afford not to make their software available on NT.
3 No, as far as I know there isn't. I didn't do any research because I have always been administering Oracle on NT servers, and that server simply was never shut down. Of course NT stops the services, which in turn.. etc... I always considered the effect of this 'crash' as marginal. 4 A while ago I came across someone making fun of the shutdown procedure of Windows by means of the startup button. But frankly, the only really stable operating systems are Unix and especially VMS. We all know what the fate of VMS is going to be. Sic transit gloria mundi!

Hth,

Sybrand Bakker, Oracle DBA

miriam wrote in message <37442305.DEBA438A_at_NOSPAM.dds.nl>...
>Hi Sybrand and everyone else who reads this,
>
>Thanks for answering my question!
>
>Sybrand Bakker wrote:
>> Yes this is true, stopping the service is equivalent to shutdown abort,
or
>> more precise: it is equivalent to crashing the database. As this is a
crash
>> comparable to a CPU crash only very little recovery should be necessary.
>> Probably that are the messages you are looking at in the alert log.
>
>So, you really mean it's not even a shutdown abort? That could explain
>some things for me. That is because I always close any open connections
>first before I shutdown my computer. (It's easy to be an administrator
>when you're the only user.. ;-)
>
>Do you know why can you stop the services like that? Is it a thing of NT
>or Oracle?
>And, more interesting, do you know how I can do a proper shutdown
>automatically when I want to shutdown my computer? (I know that it must
>be dangerous to say this in this group but when you work with a Mac you
>don't only have a startup folder but also a shutdown one and that would
>be very handy....)
>
>TIA again,
>
>Miriam
Received on Thu May 20 1999 - 10:14:45 CDT