Re: FW: Oracle on Linux

From: Tom Tyson <tomtysonjr_at_yahoo.com>
Date: Wed, 20 Sep 2000 11:08:15 -0700 (PDT)
Message-Id: <10625.117479@fatcity.com>

Paul

I have used Oracle 8.0.5, 8.1.5 and 8.1.6 on Linux on Redhat 6.1 for the past 1 1/2 years and specifically an 8.1.6 server in a production environment for at least 6 months with no real problems. That production database was a data warehouse, which might be overkill for what you need. I ran this system on a Dual Pentium III - 600 Mhz with 1 Gig Ram, and a 8 UltraSCSI disks raided disks. The disk devices were configured as two devices (Can't remember the exact size of the Raid 5 device):

( 2 disks ) = 18 gig (Raid 0 + 1) - Linux OS, Oracle executables, trace directories, redo logs
( 6 disks ) = ??78 gig?? (Raid 5 / 64k interleave factor) - Oracle data files

I formated the second disk device with a 4k block size, which by default I believe is 512 bytes. I used an 8k data block size on the database, but a 16k would have probably been a better choice. What I ended up with was a screaming fast datawarehouse. You can probably spend under $6,000.00 for a system like this, or maybe less. We used the AMI MegaRaid Controller which gave us a hardware raid solution which did a satisfactory job. The only thing I didn't like about the card was if you setup a Raid 0+1 config, it didn't balance I/O across the mirror. Other than that, it was decent. Anyway.. enough babbling.. Just one warning though, stick with the 8.1.6 release and higher.. the earlier releases were a pain!

Tom Tyson

• Paul van Dijken <paul.vandijken_at_sema.nl> wrote:
  > One of my co-workers came with this question to me.
  > Can anyone make a recommendation ?
  >
  > Regards
  > Paul
  >
  > >>>>>>>
  > I have a client who wants to try out Oracle 8 on a Linux, Intel platform.
  >
  > The requirement is to load an export of an operational database and allow a
  > single user to interrogate it with a suitable reporting tool.
  >
  > Does anyone have an experience/advice about this, initially I am thinking of
  > things such as:
  >
  > - Are there any known problems which I need to avoid
  > - Which version of Linux (Oracle Technet seems recommend Redhat - do we
  > agree)
  > - Advice on sizing a suitable Intel box
  > - Suggestions for a reporting tool
  >
  > <<<<<<<<
  >
  > --
  > Author: Paul van Dijken
  > INET: paul.vandijken_at_sema.nl
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. Received on Wed Sep 20 2000 - 13:08:15 CDT