Re: Windows2003 Server Config for Oracle 10g

On Feb 8, 10:59 am, "Charles Hooper" <hooperc2..._at_yahoo.com> wrote:
> On Feb 7, 4:41 pm, "red_val..._at_yahoo.com" <red_val..._at_yahoo.com>
> wrote:
>
>
>
> > We're awaiting a Dell 2900 PowerEdge machine with Win2003. We plan to
> > load Oracle 10g Standard Edition and import our databases from the
> > current 'production' machine, currently running Oracle8i. The main
> > application is a networked, multi-user data modeling tool which uses
> > Oracle as its data repository; and empty databases from the DDL
> > generated from the modeling tool's physical data model segment. The
> > two main Oracle databases themselves are 8 GB and 500 MB in size.
> > It's possible that we may have to support MS SQLServer on the new
> > machine, too.
>
> > The PE2900 is configured with 8 GB memory; 2x73GB mirrored root SAS
> > drives on channel0; and 8x146 GB SAS drives in 2 RAID 10 arrays with
> > each stripe set of 4 drives on separate channel of the I/O card.
>
> > The root disks will be logical C: drive, others logical D: drive.
>
> > Is this the optimal configuration for this hardware set? Can anything
> > be done better?
>
> > Also, this is my first exposure to Oracle, though I'm a veteran DBA
> > with other major DBMSes. Any words for the wise in configuring the
> > new instance?
>
> Is this the 32 bit version of Windows 2003, or the 64 bit version?
>
> I am a bit curious why you broke the eight drives into two RAID 10
> arrays of four drives each, rather than leaving the eight drives as a
> single RAID 10 array.
>
> Take a look through the following, and read the "Performance Tuning
> Guide" guide cover to cover before deciding how to set up the server.
> "Oracle Database 2 Day DBA"
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/
> b14196.pdf
>
> "Installation Guide for Microsoft Windows (x64)"
> http://download-east.oracle.com/docs/cd/B19306_01/install.102/
> b15681.pdf
>
> "Installation Guide for Microsoft Windows" - 32 bit
> http://download-east.oracle.com/docs/cd/B19306_01/install.102/
> b14316.pdf
>
> "Administrator's Guide"
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/
> b14231.pdf
>
> "Performance Tuning Guide"
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/
> b14211.pdf
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

My intention is to have each _stripe_ set on a single channel for as near to simultaneous mirroring across channels as possible, like so:

StripeSet1             StripeSet2
************             ************
Channel1               Channel2
--------------               ----------------
disk01      =====> mirrordisk11
disk02      =====> mirrordisk12
disk03      =====> mirrordisk13
disk04      =====> mirrordisk14

Channel 0 supports the root disk mirrored pair.

Does this make sense?

Now I don't know whether the Dell PERC 5/i RAID card can support this since the Dell online documentation is not sufficiently detailed, but this seems to be a (conceptual) way of optimally configuring the bulk storage. If the card doesn't support, this then it'll have to be one big RAID10 array.

Hey -- can I further logically slice the devices (either through an O/ S utility or card vendor software or 3rd-party tool) so that the D: drive comprises the first two mirrored pairs and the second two mirrored pairs are the E: drive? I just don't know.

My goal here is to do it right from the start (that last not a political statement), and avoid causing myself the angst I've experienced at nearly every IT shop I've walked into where I've found that things are not configured well, or even correctly, usually due to ignorance (or neglect) on the part of those responsible for the systems.

But it's hard to know what you don't know, and even that you don't know, hence my original post. Received on Thu Feb 08 2007 - 12:29:39 CST