Re: Periodic restart DB recommended or no ?
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 05 Apr 2008 16:41:28 -0700
Message-ID: <1207438887.66879@bubbleator.drizzle.com>
>> "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
>>
Date: Sat, 05 Apr 2008 16:41:28 -0700
Message-ID: <1207438887.66879@bubbleator.drizzle.com>
Michael Austin wrote:
> 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...
I am currently aware of two Oracle 5 databases that are up, and to the best of my knowledge have been, since the early 1990s. And they are touched, so to speak, they are part of my country's air traffic control system.
-- 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.orgReceived on Sat Apr 05 2008 - 18:41:28 CDT