learner wrote:
> Hello gurus,
>
> The DBA in our team has a task to install Oracle DB server in atleast
> 3 Sun Servers. Since, she lakcs experience and since I am unaware of
> Oracle myself I need help in this topic.
> If any one can help that will be great.
> My questions are:
>
> How many filesystems are required for Oracle DB installation and how
> do I create those filesystems using Sun Volume Manager?
> Knowing the fact the internal drive has a limit of only 7 fiesystems/
> partitions how should I create the HDD partitions?
>
> If I am missing something here please let me know.
> thanks to all.
>

I think you are missing something. While you can install Oracle on a
single internal disk, performance will be somewhere between horrible and
impossible! Oracle needs a minimum of five disks (physical disks) for
best performance. For a very small and little used database you might
get away with a single disk but, if that is the case, why are you paying
Oracle's outrageous prices? Look in the index of your Oracle
documentation for "OFA" (I think I recall that correctly). You should
find a discussion of how many disks you will need and how to lay out the
database using those disks; e.g. redo-logs get a disk by themselves, you
don't put a table and its indices on the same disk, etc, etc.

The last time I had systems running Oracle we had something like nine or
ten mirror sets (hardware RAID 1).

Oracle does not insist on a filesystem. It is quite happy with raw
disk; it just wants a lot of them. :-)