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

Hi,

I shut the database down and restarted the computer with the same result as before - no instance up. If I stop and restart the OracleDBConsoleORCL and the OracleServiceORCL manually everythings fine...

Any ideas? A colleague of mine always starts and stops his instances manually... somehow I start to realize why... ^_^

Mathias Ringhof

sybrandb schrieb:

> 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
Received on Thu Aug 17 2006 - 06:36:45 CDT