Re: Oracle 10g enterprise on windows xp pro - startup problems from time to time?

mathias.ringhof wrote:
> Hello everybody,
>
> I'm quite new to oracle so please bear with me :)
>
> I installed Oracle 10g on an old desktop pc (athlon 1,3 ghz, 512mb ram,
> via chipset), OS is a fresh and clean windows xp with sp2. What makes
> me really wonder: if I log in with the windows user without waiting
> some minutes the oracle instance isn't coming up. enterprise manager
> tells me that the listener is started, but instance is down. I waited
> about 5 to 10 minutes, nothing happend. If I wait for about 3 to 5
> minutes before I log in everythings fine!
>
> Thanks for any help / suggestions in advance! :)
>
> Mathias Ringhof

Very much sounds like no clean shutdown (ie shutdown abort), followed by the inevitable crash recovery at startup. Both can be tracked by means of the alert, located in the background_dump_dest directory.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA