The problem is that rpm doesn't handle the dependency checking, i.e. making sure the pre-requisite RPMs are installed before you start. If you're willing to reinstall, the simplest method is to customise the installation and enable the Oracle Validated package. This package ensures that all the prerequisite software is installed to enable you to immediately install Oracle Database 10g or 11g.
To install the Oracle Validated package during installation:
1. Follow the installation process as normal until you get to the first software selection screen (it lists a series of tasks that you can add support for, and has an option at the bottom: "Customize Later" and "Customize Now"
2. Select the "Customize Now" option and click Next
3. Select "Base System" in the left-hand list and then "System Tools" in the right hand list. Click the checkbox next to "System Tools", then click the "Optional Packages" button.
4. Scroll down and select the "oracle-validated" package and click "Close"
You can now click "next" and continue the installation as normal. This also creates the oracle user/groups, sets up sysctl.conf, limits.conf, etc. It's fairly nifty.
If you don't want to reinstall, you need to use the up2date tool to register with Unbreakable Linux Network, which requires a CSI (i.e., you have to buy at least Network level access).
If you don't want to reinstall and you don't have a CSI, you will need to create a local yum repository from the source CDs. This is slightly more complicated, so let me know if you want me to go into this option.
