Re: Stop Oracle Service:

'bonehead wrote:

> 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.)
>
> 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?

The bone-head is your instructor. Have him contact me if they want. He is incorrect about every version of Oracle going back at least 15 years and probably 20 or more.

There is never a reason to shut down the database service for anything you will be learning in your class except perhaps cold backups.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)