Re: Oracle 9i 365-day reboot issue

From: Walt Weaver <>
Date: Fri, 8 Aug 2008 10:05:10 -0600
Message-ID: <>

Thanks Dan! If you're in Bozeman this weekend I'll take you up on it. :>)

And, thanks for the info.


On Fri, Aug 8, 2008 at 9:51 AM, Daniel W. Fink <>wrote:

> Walt,
> First...HAPPY BIRTHDAY! I'll buy you a beer if I ever make it to Bozeman :)
> Second, this may be a case of one issue being carried over to another. I
> recall that certain Unix systems (HP-UX?) required a periodic bounce because
> some of the Oracle memory structures/counters were not large enough to
> handle the numbers that would be generated over time. I have not had to deal
> with this issue in quite a while, so it may have been a 32 bit issue as
> well.
> I did a search on metalink and came up with nothing.
> Regards,
> Dan
> --
> Daniel Fink
> Help me support The Children's Hospital of Denver! I'm riding in the 2008
> Courage Classic - 157 miles in 3 days
> Help me reach my goal of $2,500.00 in donations. Visit my Personal Rider
> Page to donate
> - Oracle Performance, Diagnosis, Data Recovery and Training
> OptimalDBA
> Oracle Blog
> Lost Data?
> ------- Original Message -------
> On 8/8/2008 3:00 PM 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:05:10 CDT

Original text of this message