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

You should use the sqlplus method to perform 'routine' startups and shutdowns on the database.

There's no relation between SQL Plus and services because that's how the Oracle architecture is implemented on Windows. You can't actually issue a startup command in SQL Plus until and unless the service has already been started. And, as you say, shutting down in SQL Plus doesn't stop the service.

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. Making a SQL Plus shutdown also stop the service would therefore render SQL Plus unuseable until you had clicked all round the houses and re-started the service. Given that there are many, many reasons for doing a quick Instance shutdown, that would be a royal pain. Oracle's solution is much more sensible.

The only time you need to stop the service, and when a boring old sqlplus shutdown isn't good enough, is when you need to delete or move database files. Otherwise, stick to sqlplus.

Regards
HJR "José Arango" <arango_at_caribe.net> wrote in message news:ulaq8bbksavae5_at_corp.supernews.com...
> Hello everyone,
>
> I'm learning Oracle so I installed Oracle 8i (Release 2) on my Win2K
laptop.
> There are two ways for starting the database: one is thru Control
> Panel/Administrative Tools/Services and the other using Sql*Plus and then
> typing startup. I wonder: which method is better?
>
> I have noticed that if I shutdown the database in SqlPlus...it doesn't
sync
> up with Services. I mean...When I shutdown the DB in Sqlplus I'm thinking
> that when I'll go to Services I'll see the Database entry as STOPPED and
> the thing is that it's still saying STARTED (how come?).
>
> Please share your comments.
>
> thanks in advance,
> José
Received on Sat Aug 10 2002 - 15:24:01 CDT