Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best Practices - Oracle Server Reboots

Re: Best Practices - Oracle Server Reboots

From: <twod_at_not.valid>
Date: 1997/12/10
Message-ID: <66lf94$nh8$5@vnetnews.value.net>#1/1

djones_at_ccs.lmco.com wrote:
: Does anyone have a feel for how long most Oracle databases are kept up
: between being rebooted. We have an Oracle server which normally stays up
: about a month before having to be rebooted. Is this average? I'd like to
: get a feel for what best practices are in the field.

You do not reboot an Oracle database.

You reboot a machine - you do mention a databse server, so lets proceed assuming you mean 'how often should I reboot the machine that is my database server'.

The simplistic answer is that the database does not generally require an OS reboot. As long as your db is chugging along happily and is correctly backed up then why change that scenario ?

Some System Admins like to reboot a machine every now and then for various reasons - to clear '/tmp' (I have heard that from a pyramid sys admin, so please no smirks); to kill zombies; to help reduce the impact of memory leaks ; etc.

We have a number of platforms at work - Unix (various vendors) + VMS - and the database servers stay up for any number of months, certainly for the period specified within our service agreements with the end-users -- for the record the VMS clusters are the most reliable - ouch it hurts me to type that :)

If your machine absoltely has to be rebooted about once a month then I'd have a little think about why.

If you are running a non-real OS such as a MS (Messy & Shoddy) OS then the above does not apply and you are on your own. Only *real* OS' need apply.

IAP

--
I am using anti-spam measures, please replace 'not.valid' with 'value.net'
Received on Wed Dec 10 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US