Re: Win2K- How to start DB? thru Services or Sql*Plus?

Totally different architectures. On Unix, Oracle is a multi-process architecture. On Windows, there's one process, but with multiple threads within it -it's a genuinely multi-threaded architecture, in other words.

So there's no equivalent in Unix for starting the Windows service -the architecture doesn't require it.

I assume that Windows requires the service so as to establish the process/threads and associated process memory. On Unix, each process can be spawned dynamically, and grabs its memory allocation as spawned. I guess it's technically impossible for threads to grab memory on-the-fly.

The way I always explain your specific question is this: the service is not the Instance, but it's the (Windows)architectural underpinning of the Instance. That's why killing the service kills the Instance, but not the other way around.

But we're delving into the realms of Windows programming here, so I'll bow out and let someone more qualified continue as they see fit!

Regards
HJR "José Arango" <arango_at_caribe.net> wrote in message news:ulba7vgve6pjd1_at_corp.supernews.com...
>
> First, thanks Howard and Sybrand for helping on my two posts. I found your
> info extremely helpful.
>
> Now...
>
> Howard J. Rogers wrote:
>
> > I'm not sure why, it's just the way things are. In effect, you need the
> > service to provide the shared memory and thread/process components
needed
> > to make SQL Plus commands do their thing
>
> This obviously makes sense. Do you have any idea how is this implemented
on
> Unix? I don't remember starting up a process in Unix before doing a
sqlplus
> to startup the database. Maybe that "process" was already started.
>
> I know what an instance is and what opening and mounting a database is but
> I'm wondering....Is this process (the one that Sqlplus talks to before the
> database is up) part of the instance? I don't think so...since starting an
> instance is part of the "startup" command. So then..what is that needs to
> be run (that thing call 'a service' on Windows) on Unix to use Sqlplus and
> then start the db?
>
> Thanks!
> José
>
>
Received on Sat Aug 10 2002 - 19:53:27 CDT