RE: Oracle 9i 365-day reboot issue
Date: Fri, 8 Aug 2008 10:51:39 -0500
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.
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
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