Re: Oracle 9i 365-day reboot issue

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

And, thanks for the info.

--Walt

On Fri, Aug 8, 2008 at 9:51 AM, Daniel W. Fink <daniel.fink_at_optimaldba.com>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 http://www.couragetours.com/2008/danielwfink to donate
>
> OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training
>
> OptimalDBA http://www.optimaldba.com
> Oracle Blog http://optimaldba.blogspot.com
>
> Lost Data? http://www.ora600.be/
>
>
>
> ------- 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
>

--
http://www.freelists.org/webpage/oracle-l