Re: Oracle DB Best Practices on Linux x86_64

A Sample Output for edb360 is available at this Dropbox: https://www.dropbox.com/s/wm3apncqvtrur7t/edb360_sample.zip

You may want to also consider: Oracheck _at_ MOS 1268927.1

Cheers,
Carlos Sierra
carlos.sierra.usa_at_gmail.com
Life is Good!

On Jul 29, 2014, at 11:05, Steve Gardiner <gardiner9_at_gmail.com> wrote:

> I've been using Carlos Sierra's edb360 as a sanity check.
>
> https://www.enkitec.com/products/edb360
>
> I set my AWR retention to 31 days and run it every month.
> Run it as oracle and it will find all the databases on the host and report on them. RAC aware.
> Great product and it's free.
>
>
> Steve Gardiner
> gardiner9_at_gmail.com
>
> LinkedIn Profile
> www.linkedin.com/pub/steve-gardiner/a/724/88a/
>
> This Day in Computer History
> http://www.computerhistory.org/tdih/
>
>
> On Mon, Jul 28, 2014 at 3:16 AM, Justin Mungal <justin_at_n0de.ws> wrote:
> I have an interesting request from a customer to review the Oracle configuration on a couple servers for best practices. I've been checking things over; I haven't had a chance to talk to the customer yet, but seeing from the load I'm guessing they aren't in production yet.
>
> Right now I've just looked at the very basic things that tend to come back and bite later on, or are just good things to configure in general: backups, multiplexed control/redo logs, memory settings, patch levels, log rotation, etc... but then again not all of them may be necessary, depending on the customer's needs.
>
> Has anyone created some kind of generic best practices document, or a checklist of some kind? Arup Nanda's document from 2007 has some good points, so I would be looking for something like that I suppose.
>
> Thanks,
> Justin
>

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