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

On Sat, 10 Aug 2002 15:28:55 -0400, José Arango <arango_at_caribe.net> wrote:

>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é

sqlplus can't stop and start a win2k service. If you want to do that manually you need the oradim program. This is logical because the service concept is NT/Win2k specific and sqlplus is a generic tool for all platforms
If you type oradim -? in a Dos box you see that you can use oradim to start and stop the database, but you can also use it to start and shut a service.
However, if you want to make a cold backup, you need to make sure both the database and the service has been stopped, so you need oradim

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 10 2002 - 15:07:51 CDT