Java Mailing List Archive

http://www.redhatconfig.com/

Home » Red Hat Enterprise Linux 5 »

Re: [rhelv5-list] Re: Oracle on Red Hat best practices

Leo Pleiman

2008-01-23


Author LoginPost Reply
Do we have a white paper or a supported configuration for Oracle on
RHEL5.1 as Xen guests?

Chuck wrote:
> Try this site:
> http://www.puschitz.com/
>
> I have been using his guides for years. (even as an employee at Oracle
> I found myself using his guides over the wordy/lengthy oracle docs)
> You also wanna become familiar with the Oracle architecture. There are
> various components you want to segregate onto different physical
> spindles. Oracle has what they called the OFA - optimum Flexible
> Architecture. This covers what components should go where. (ie: You
> don't want 2 log groups on the same filesystems, not only are you
> getting redundant I/O per every transaction but you have lost the
> redundancy if that filesystem fails. You also don't want to store a
> table's indexes on the same filesystem as the table itself -- so place
> index tablespaces on separate spindles from the corresponding data
> tablespaces. There are just a few examples)
>
> Other than that, avoid raid 5 for OLTP databases if you can, and I
> personally avoid using NFS for storing datafiles, although Oracle uses
> NFS for datafiles for almost 90% of their databases. (10 years ago
> Oracle documentation stated don't EVER mount datafiles accross NFS but
> today, after being in bed with NetApp all these years, its apparently
> ok to do)
>
> Of course all this is based on your planned workload. It is possible
> to store an entire database all in one filesystem but you won't be
> able to scale much, nor will you be able to recover 100% of your
> transactions (100% of the time) if that filesystem fails.
>
> Hope this helps,
> CC
> On Nov 8, 2007 9:45 AM, McDougall, Marshall (FSH)
> <Marshall.McDougall@(protected):
>  
>> I am being tasked with building an environment to run Oracle. I have
>> had little Oracle experience so I went looking on the web for some best
>> practices for file system setup. Of course there were several million
>> hits and with variety comes confusion. I would appreciate it if someone
>> with some Oracle on Linux expertise would point me in the right
>> direction. I believe that the hardware is going to be HP blades
>> connected to an EMC/Dell SAN. Thanks for your consideration.
>>
>> Regards, Marshall
>> --
>> redhat-list mailing list
>> unsubscribe mailto:redhat-list-request@(protected)
>> https://www.redhat.com/mailman/listinfo/redhat-list
>>
>>  
>
> _______________________________________________
> rhelv5-list mailing list
> rhelv5-list@(protected)
> https://www.redhat.com/mailman/listinfo/rhelv5-list
>  

Attachment: lpleiman.vcf (zipped)
_______________________________________________
rhelv5-list mailing list
rhelv5-list@(protected)
https://www.redhat.com/mailman/listinfo/rhelv5-list
©2008 redhatconfig.com - Jax Systems, LLC, U.S.A.