Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Theoretical Question OracleService<SID>
Lanying & Manfred wrote:
> ORA !=g WIN XP PROF
>
> When shutting down an Oracle Instance via sqlplus
>
> shutdown immediate;
>
> the ORACLESERVICE<SID> is still running. What in the hell is the
> oracleservice<SID> doing? Launch pad for a start up sequence?
>
> startup blah blah blah?
>
> A theoretical question only!
>
> Regards Lanying
>
>
>
There is a difference between the service and the instance. Oracle on Windows requires a service to be running before the instance can start. Shutting down the instance does not stop the service. However, stopping the service will shut down the instance.
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Tue Apr 04 2006 - 13:21:13 CDT