Your question suggests that your interest is in how Oracle's software will function.
( ... and on inexpensive PeeCee equipment )
Perhaps you should ask Oracle instead of whatever company produces the OS.
http://www.oracle.com/database/index.html
http://forums.oracle.com/forums/categoryHome.jspa?categoryID=84
http://www.oracle.com/technology/documentation/database10gr2.html
We make use of Oracle 10G on RedHat AS 4 and some DB抯 on Solaris 10 x86 in zones.
In my option Solaris is a better choice.
Reasons:
Patching the Linux kernel is a mess, we once found that we could not refresh the DB to the test nodes after a kernel upgrade, Oracle relink failed, and the funny thing is that kernel level was certified had to run on old kernel again, wasted time.
Network drivers stopped also after the kernel updates since we have to reinstall the HP Proliant support pack due to the drivers being compiled during the installation process for the affected kernel.
EMC powerpath also have to be updated for every kernel update they have a new powerpath install.
No DTRACE
We do not have these problems on the solaris nodes when upgrading/patching.
If linux is your passion go with it, if you just want to collect your pay check Solaris in my option.
Oracle is not yet certified on RH 5, not that my option will change.
One more thing, if you do not run 64bit Linux go for Solaris. Oracle is only supported on Solaris x86 in 64 bit.
Unless you have a small db or it will not be used in a heavy OLTP environment, I guess 32 bit is ok. You cannot assign more than 4GB of memory to a process in 32bit (like many have found out the hard way) and even then you have to run the hugemem Linux kernel. That puts the Oracle SGA at 3.42GB max, not much room for proper caching in today抯 world. Yes you might have fast enough disks but, it will never be as efficient as the ability to add memory and increasing the buffer size for Oracle.