Home » Infrastructure » Windows » OracleService to stop and start database
OracleService to stop and start database [message #101185] Tue, 08 June 2004 09:45 Go to next message
Messages: 37
Registered: February 2000
I need am confused.  To start and stop a database the following is recommended in metalink.

stop database

stop service

start service

start database

But we also know if you have your service OracleService<SID> set to automatic and regedit ORA_SID_AUTOSTART=TRUE the database will startup upon reboot and if ORA_SID_SHUTDOWN = TRUE the database will be properly shutdown if the system is shutdown.

So my confusion is:  Does "net start OracleService<SID>" start up the database?  If so, why do all the scripts have "net start OracleService<SID> and then "startup"?  What is the purpose of the startup?  If not, how does the database get started upon bootup without the startup?

Does "Net stop OracleService<SID> actually shutdown the database or do I need to proceed with "shutdown immediate"





Re: OracleService to stop and start database [message #364769 is a reply to message #101185] Wed, 10 December 2008 00:28 Go to previous messageGo to next message
Messages: 1
Registered: December 2008
Junior Member
Hi Monica,

Even I have the same doubt...Did you get any idea on this?

Please reply ...

Re: OracleService to stop and start database [message #364785 is a reply to message #364769] Wed, 10 December 2008 00:51 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Platform Guide 10g Release 2 (10.2) for Microsoft Windows
Chapter 5 Administering a Database on Windows

Previous Topic: Oracle 8i on Windows 2000 vs NT
Next Topic: INSTALL oracle 8i whith developer 6i enerprise
Goto Forum:

Current Time: Thu Aug 24 03:54:22 CDT 2017

Total time taken to generate the page: 0.01869 seconds