Installing rpm & dependencies

view story

http://unix.stackexchange.com – I am trying to install an rpm, namely the Oracle 10g database for CentOS 6 for testing an app. The problem is that the machine the OS is installed on does not have access to the internet and there is a list of dependencies that the 10g needs which also have other library dependencies. With 'yum' being unhelpful in this case, is there somewhere or a way dependencies for an rpm can be downloaded without having download each one individually? (HowTos)