RPMs are packages. (RPM = Redhat Package Manager).
You can find RPMs for RH 9 on places like rpmfind:
www.rpmfind.com. (See rpmseek there.)
That site will let you search for specific packages and will show you locations for rpms for RH9 and other distros.
However RH9 is really old. If you really want to update everything you should consider installing something more current.
After RH 9 RedHat took their name back for commercial distributions so those are now called RHEL (RedHat Enterprise Level). The equivalent non-commercial distributions were rebranded as FC (Fedora Core). FC6 is out already so you are 6 major release back.
I wouldn't recommend going to FC6 as it is bleeding edge but you should at least go to FC4 as it is the first one that had the 2.6 kernel (FC3 has the 2.4 kernel) which is a significant change that all newer distros are using.
Also by going forward you can use "yum" to do subsequent updates instead of installing individual rpms. The main benefit being that there are usually dependencies between rpms so when you try to install one it tells you it needs another and then that one tells you it needs another etc... It can get quite maddening and yum gets rid of all that madness.