Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Minimum Hware platform for 9i on Solaris 9

    *New DBA alert!*

    My question is:
    What is the minimum sparc cpu that I need to run oracle9i on solaris9 at a rate suitable for a single-user development/test environment?

    ============================================

    For experience, I'm planning to build solaris 9 and oracle 9i platform onto a Sun w/station. Gathering info on cheapest platform I can reasonably get away with at the moment. Have confirmed 9i runs on 9...


    Went to sun.com first and found following info:

    http://docs.sun.com/db/doc/817-2701/6mibjiobo?a=view
    ====================================
    To install or upgrade to the Solaris operating environment,
    the suggested memory size is 128 Mbytes or greater.

    Entire Solaris Software Group Plus OEM Support 2.9 Gbytes


    http://docs.sun.com/db/doc/816-1664-10/6m82lv9lf?a=view
    ======================================
    Supported desktops: Ultra 10 and Sun Blade 100


    Went to oracle.com next to find out what 9i needs as a hware platform and as usual couldn't find anything I hunted/searched for. I am an oracle-certified dba and I often find getting answers out of oracle.com
    close to impossible. Perhaps I needed to look harder?...

    Anyway googled for a while on oracle 9i and turned up following answers


    http://www.dbasupport.com/oracle/ora..._compare.shtml
    ============================================

    To install Oracle 9i Database under the UNIX Systems, such as
    [...Sun Solaris...], you should have the following hardware:

    Memory A minimum of 512 MB RAM
    Swap Space A minimum of 2 x RAM or 400 MB, whichever is greater
    Hard disk space 4.5 GB [this statement makes no sense, as 2xmin ram = 1gb which is clearly > 400Mb]


    By far the best article I found was the following:

    http://www.databasejournal.com/featu...le.php/3293661
    ============================================

    System Requirements
    The list below details the system requirements.

    64-bit Support: As root, execute isainfo -v at a UNIX prompt.
    If you see the following output, your server supports 64-bit in
    addition to 32-bit applications.

    64-bit sparcv9 applications
    32-bit sparc applications

    If you do not see the 64-bit line or receive a "Command not found"
    error, contact your UNIX system administrator and verify your intended
    server is 64-bit enabled.

    Memory: 512MB of RAM to install the Oracle9i Server. To determine the
    memory on your workstation, see the example below:



    # /usr/sbin/prtconf | grep "Memory"
    Memory size: 512 Megabytes

    Swap Space: amount of disk space equal to the system's physical memory,
    or 1GB, whichever is greater. df -k | grep swap will show available swap
    space in kilobytes (swap space may be on more than one device/disk).

    Disk Space: 3.5GB for database software and 1GB for the seed database
    created during installation. Create the seed database as a means of
    confirming the Oracle program files work. If you do not want to keep
    it, delete the seed database to recapture the disk space.

    Temporary Disk Space: Up to 400MB available in the /tmp directory or
    other location identified via environment variables (TEMP, TMPDIR).
    Execute df -k | grep tmp at a UNIX prompt to see how much space is available.


    Conclusions
    ========
    I plan to buy a u10 or blade 100
    9 gb of disk space for starters (plan to acquire 2x9gb disks)
    512Mb ram (sun memory isn't cheap)
    unknown sparc cpu clock speed (still hunting for this)

  2. #2
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    There are plenty of used/refurbished Sun workstations available on ebay and from a number of vendors.

    I personally use an Ultra 30 with 1GB memory a 300Mhz proc and 2 x 36GB 15K drives (it came with 2 x 4GB) this system ran me under $500 with shipping and I picked up the new hard drives new for just under $200 total.

    I routinely work with instances ~30GB on this machine without getting frustrated.

    You can probably find a nice Ultra 30 or 60 (possibly with dual cpus) with 1GB of memory and enough disk space for $500-$700 or even less if you are in the right place at the right time.
    drew
    ------------------
    http://wjtechnologies.com

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    Smile

    Hi Drew,

    Thanks for taking the time to respond to my post - It's much appreciated.

    Knowing the spec you detailed is v. useful to me. I've had my eye on ebay for some time, but I'm in the UK and most US vendors refuse to ship to here. The prices on ebay.co.uk are about 25%+ higher than on ebay.com for the same w/stations, and vendors are no better.

    I now have a solid idea of the type of spec (particularly sparc cpu) that I should be looking for in the machine I buy.

    I'll bite the bullet sometime soon, though my wallet is recovering from Christmas and my new http://goldtouch.com/purchase/keyboard.html.

    Regards from Scotland,

    Barry



    Originally posted by drew
    There are plenty of used/refurbished Sun workstations available on ebay and from a number of vendors.

    I personally use an Ultra 30 with 1GB memory a 300Mhz proc and 2 x 36GB 15K drives (it came with 2 x 4GB) this system ran me under $500 with shipping and I picked up the new hard drives new for just under $200 total.

    I routinely work with instances ~30GB on this machine without getting frustrated.

    You can probably find a nice Ultra 30 or 60 (possibly with dual cpus) with 1GB of memory and enough disk space for $500-$700 or even less if you are in the right place at the right time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •