Re: Periodic restart DB recommended or no ?
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sat, 05 Apr 2008 19:13:00 GMT
Message-ID: <0bQJj.508$h75.312@newssvr27.news.prodigy.net>
>> zigzagdna_at_yahoo.com wrote:
>>
>>> My Windows Servers are rebooted every weekend, so Oracle gets rebooted
>>> as well. I have found that if servers are not rebooted (once Windows
>>> automatic reboot job was not working), Oracle as well as other
>>> applications on the server started giving problems.give sproblems.
>>> On HP UNBIX Servers, this weekly reboot is not requied, servers are
>>> rebooted only when OS patch is installed (every 3 to 6 months).
>> I'm running 10gR2 under Oracle Linux on a couple of HP boxes (DL360 and
>> DL380) and from the day they were moved into the current data center
>> they have never been rebooted. I'd suggest getting a different O/S.
>> --
>> Daniel A. Morgan
>> Oracle Ace Director & Instructor
>> University of Washington
>> damorgan_at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
Date: Sat, 05 Apr 2008 19:13:00 GMT
Message-ID: <0bQJj.508$h75.312@newssvr27.news.prodigy.net>
Shakespeare wrote:
> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht > news:1206978408.713883_at_bubbleator.drizzle.com...
>> zigzagdna_at_yahoo.com wrote:
>>
>>> My Windows Servers are rebooted every weekend, so Oracle gets rebooted
>>> as well. I have found that if servers are not rebooted (once Windows
>>> automatic reboot job was not working), Oracle as well as other
>>> applications on the server started giving problems.give sproblems.
>>> On HP UNBIX Servers, this weekly reboot is not requied, servers are
>>> rebooted only when OS patch is installed (every 3 to 6 months).
>> I'm running 10gR2 under Oracle Linux on a couple of HP boxes (DL360 and
>> DL380) and from the day they were moved into the current data center
>> they have never been rebooted. I'd suggest getting a different O/S.
>> --
>> Daniel A. Morgan
>> Oracle Ace Director & Instructor
>> University of Washington
>> damorgan_at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
> > I have seen a VAX VMS Oracle 7?/8? don't remember) server not being rebooted > for a long long time, ending up running an outdated oracle version. > Once it was rebooted, it never came up again.... > > Shakespeare > >
There have been VMS boxes (VAX and Alpha) that had uptimes in excess of 5-10 years. I was doing some data-center "moves" of servers and came across a 7.3.3 db that had been up and running for more than 5 years (I believe it was Solaris or HP), but the only reason is stayed up that long is that no one even touched it in that timeframe... Received on Sat Apr 05 2008 - 14:13:00 CDT