Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database won't mount, but no errors reported ???

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

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 18 Jan 2003 17:48:40 +1100
Message-ID: <uD6W9.26997$jM5.70737@newsfeeds.bigpond.com>

"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
>
>
>
Received on Sat Jan 18 2003 - 00:48:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US