Re: Oracle 9i 365-day reboot issue

From: Robert Freeman <>
Date: Fri, 8 Aug 2008 09:01:25 -0700 (PDT)
Message-ID: <>

Remember getting hit by this one long ago. Ahhh memories!!


 Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: (Oracle Press) The LDS Church is looking for DBA's. You must be LDS to apply (please don't write to me and tell me I'm breaking the law. A church can choose to hire members of it's own faith. Look it up if you don't believe me).

  • Original Message ---- From: Riyaj Shamsudeen <> To: Cc: Sent: Friday, August 8, 2008 9:39:36 AM Subject: Re: Oracle 9i 365-day reboot issue

Hey Walt
I remember you :-)
That bug was between 8.0.x to 8.1.6 due to timer overflow. Note 118228.1

  Operating systems with clock ticks set to milliseconds will see this   problem after 24.8 days but typically systems have clock ticks set   to centiseconds which means the problem would not be seen for 248 days.

The Pythian Group

Walt Weaver wrote:
> Hello all,
> Some of the older list members may remember me; I've been more or less
> away from Oracle for a few years but we still have a few old 9i
> systems I still maintain on a sporadic basis.
> Anyway, one of our few remaining Oracle customers recently requested
> that we bounce the Oracle instance they were on; they said there was a
> bug in 9i that required the instance be bounced at least every 365 days.
> Does anyone know anything about this? I haven't been able to find out
> anything about it; my Metalink account expired a long time ago and
> Googling hasn't turned up anything.
> Any information will be greatly appreciated.
> Thanks,
> --Walt Weaver, old Oracle fart (it's my 60th birthday today)
> -- Bozeman, Montana

Received on Fri Aug 08 2008 - 11:01:25 CDT

Original text of this message