Re: Windows2003 Server Config for Oracle 10g

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. Received on Thu Feb 08 2007 - 09:59:52 CST