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

Found a solution for the shutdown problem: since OS is windows the local security policies had to be set correctly. the user that you want to use to shut the database down needs to have the right "logon as a batch job".

mathias.ringhof schrieb:

> 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:20:23 CDT