Re: Database won't mount, but no errors reported ???

"Howard J. Rogers" wrote:

> "JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message
> news:it6W9.7084$F_3.220_at_news.bellsouth.net...
> > As everyone else has said, this is a known issue on Solaris.
> >
> > FYI... When Oracle hangs at startup, a good trick to see more
> informational
> > error messages is to turn on trace at the server level with init.ora parm
> > sql_trace=true. Not sure what it would say, but I know 1 time this came in
> > handy when we hit the max open files set at the kernel level.
> >
> > Just do not leave this parm in the init.ora, it generates a billion trace
> > files.
> >
> > Note: Has anyone ever heard of Windoze machines being up for over 7 months
> ?
>
> I have a Windows 2000 server that's been up for 16 months. It would have
> been longer, but we had a power cut, and that was before I got my UPS.
>
> Regards
> HJR
>
> > We schedule nightly reboots on most of our Windoze servers and thankfully
> I
> > don't work on those. We , of course , run Oracle on a real OS.
> >
> >
> > "Mike Heden" <mheden_at_bigfoot.com> wrote in message
> > news:53b3de4.0301161226.1a864131_at_posting.google.com...
> > > A system running Oracle 8.0.6 under Solaris failed overnight.
> > > Attempts to restart it just hang. If I do a startup nomount, it
> > > reaches a 'started' state OK and server manager comes back with its
> > > prompt. On the other hand if I do a startup mount it hangs. There's
> > > nothing in the alert log that indicates any sort of problem - the last
> > > entry is 'alter database mount'. I've also left it a long, long time
> > > just in case it was taking its time loading, but that has made no
> > > difference. Once it's in this hung state, not even control-C gets a
> > > response - the telnet session to the server appears dead.. There are
> > > no dumps and there's nothing in dmesg to indicate a more fundamental
> > > problem.
> > >
> > > I've tried restoring from a full hot backup taken the previous night,
> > > but the results are exactly the same.
> > >
> > > Fortunately this is an inactive legacy system that is only used
> > > occasionally to provide access to old, virtually-static, data. My
> > > next step is probably going to be a restore from the last cold backup.
> > >
> > > Am I missing something here? I haven't seen Oracle 'fail silently' in
> > > this way before, so I'm inclined to think it's not a database problem.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Mike
> >
> >
> >

How many user's?
How many transactions?

Daniel Morgan Received on Sat Jan 18 2003 - 11:35:41 CST