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

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Fri, 17 Jan 2003 09:10:21 +0100
Message-ID: <b08dmv$alv$1@news.mch.sbs.de>

"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:b07o7s$q8d$1_at_reader01.singnet.com.sg...
> I ever met the same problem on 8.0.5, you need to reboot the machine, then
> everything should be ok.

Yes, that's a known anomalie of Oracle 8.0. It happens when your server has a livetime of more than 248 days.
It's because the number of ticks measure by the system (248 days * 24 hours * 60 min * 60 sec * 100 ticks) crosses the 32bit imposed 2e31 limit (becomes a negative value). The only solution is to reboot your server.

Stephan

BTW: It never ever happens on NT/W2k!!! Any guesses? ;-)) Received on Fri Jan 17 2003 - 02:10:21 CST