Re: Windows OracleService msytery

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 17 Feb 2006 07:09:32 +0100
Message-ID: <43f5689b$0$27909$626a54ce@news.free.fr>

"Randy Harris" <randy_at_SpamFree.com> a écrit dans le message de news: ZgbJf.30897$F_3.17253_at_newssvr29.news.prodigy.net...
| I've got an odd problem with 9i (9.2.0.4) on Windows XP, hoping that someone
| can give me a pointer in the right direction.
|
| The database is not starting with the system service. I can start the db
| with sqlplus, no problem. When the system boots, the server service starts
| but it doesn't start the database. The alert log shows no indication of why
| that is. It does indicate, however, that the service is not shutting down
| the database either. I can stop and restart the service, but the instance
| is crashed and does not restart until I start it with sqlplus. Any idea why
| this might be?
|
| --
| Randy Harris
| tech at promail dot com
| I'm pretty sure I know everything that I can remember.
|
|

Add this value to your registry:
HKLM\Software\Oracle\HOMEx\ORA_<SID>_AUTOSTART -> TRUE

where x is your Oracle home number (0 unless you have multiple homes) and <SID> your Oracle SID.

Regards
Michel Cadot Received on Fri Feb 17 2006 - 00:09:32 CST