| OracleService to stop and start database [message #101185] |
Tue, 08 June 2004 09:45  |
Monica
Messages: 37
Registered: February 2000
|
Member |
|
|
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"
Monica
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
