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

Hi,

thanks for your quick reply. I think you were right, there is something about crash recovery in the log when the database starts up. Can't I just shutdown the OS or do I have to stop the instance before shutting down?

Btw, I tried to shut the instance via the web interface down and he keeps telling me wrong username/password, but it's definitly correct... phew, I might have a lot to learn ^_^ never had this kind of trouble with my old ms sql 2000...

Thanks again!

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:12:44 CDT