Startup/Shutdown of database on Windows

[vbcdor]

Hi,
How are the Oracle databases normally started and shutdown on reboots on W2K servers? I know the services are started and stoped by the OS, but what about the database itself?

 

[LKBrwnDBA]

The database itself is a service (OracleServiceXXXX) where XXXX is the database sid.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Vbcdor,

As an alternative to stopping/starting the Windows service, you can bounce an Oracle database on Windows by logging into SQL*Plus and issuing a standard shutdown/startup series:

c:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate (or "abort" if necessary)
SQL> startup

Let us know your results,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:41 (28Jan05) UTC (aka "GMT" and "Zulu"),
@ 09:41 (28Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[vbcdor]

thanks, I thought there was more to it than that. so if I don't want the database to start back up between reboots, I can just disable or change the service to manual.

 

[SantaMufasa]

That is correct.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 19:12 (28Jan05) UTC (aka "GMT" and "Zulu"),
@ 12:12 (28Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.