Hi
If you are using Oracle then you should (obliged to) go with Oracle supported software. In your case the OS should be Red Hat (or Suse, White Box, etc) but check with
http://metalink.oracle.com (navigate to the Certify tab) for specific versions. They'll also have soltuions geared up for what you've mentioned but this will depend on the budget. Assuming this is a production system it's best to ensure that the tech. stack is supported.
There are other solutions though, for example Mysql with Openmosix and Apache etc
If you require more info mail me on
oracle@wol.co.za.
Hope this helps
Graeme