Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stop Oracle Service:

Re: Stop Oracle Service:

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 26 Jan 2004 11:05:19 -0000
Message-ID: <4014f467$0$28128$cc9e4d1f@news.dial.pipex.com>


"'bonehead" <senmenospam_at_here.org> wrote in message news:40144CFF.2030500_at_here.org...
> I am an Oracle brand-spankin-newbie using 9i Personal on a Win2K
> workstation.
>
> My CS instructor states that it is important to turn off the Oracle
> database service when quitting SQL+. However, he was not familiar with
> 9i so he could not show me how to do this. Presently I am just going to
> the Task Manager and ending the oracle.exe process there (I am also
> stopping the Oracle Apache server.)

It would seem to me that your instructor, assuming he exists, is neither familiar with Oracle nor the operating system that you are using. The biblical comparison of the blind leading the blind seems appropriate here.

To stop a service in windows use the services control panel applet. This works just as well for Oracle services as any other.

There is some documentation on 9i at http://tahiti.oracle.com which covers the different ways in which Oracle can be stopped. You might wish to get your instructor to read it. You might also question why you are using personal and not enterprise edition.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************







>
> 1. Is it correct that I should stop the database service when exiting
> SQL+? Why/Why Not? It seems like a reasonable thing to do, if only
> because of the system resources it consumes.
>
> 2. If this is correct, am I doing it the right way? If not, what should
> I do instead?
>
Received on Mon Jan 26 2004 - 05:05:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US