Re: Oracle DB Best Practices on Linux x86_64
Date: Mon, 28 Jul 2014 15:48:27 -0500
Message-ID: <CAO9=aUzdugJPckUHfdZgMORE1+ZKBXG-08ELv7XW5y=w8xAM3Q_at_mail.gmail.com>
Thanks Seth! Funny how I knew about RACchk but not ORAchk, it sounds like exactly what I need. I'll also check through the automation features, as you mentioned.
-Justin
On Mon, Jul 28, 2014 at 11:40 AM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:
> Justin,
>
> I would suggest running the latest ORAchk (1268927.2) on all of the
> systems in question. The results of the tool will show violations of and
> recommendations for best practices. This will also address some of the
> items you listed, like multiplexing control files and redo logs. MOS
> recommends running this monthly.
>
> Enterprise Manager can be used to monitor things like patch level and make
> opening support tickets MUCH easier and in some cases automatic.
>
> Use the automation features of the database like Automatic Memory
> Management (AMM) which implicitly uses Automatic Shared Memory Management
> (ASMM), Automatic Undo Managment, Automatic Segment Space Management
> (ASSM), Automatic Diagnostic Repository (ADR) and the maintenance jobs to
> name a few.
>
> Anything left over after these things is probably based on the database
> requirements and needs to be defined by the customer.
>
> Seth Miller
>
>
>
> 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-lReceived on Mon Jul 28 2014 - 22:48:27 CEST