I found a great link showing how to use the Oracle Linux DVD as a repository for yum. Although the post mentions using the DVD, you could probably setup 6 repositories with the 6 CDs to make it would for the CDs too.
Having Yum is very powerful because it figures out the prerequisites for installing software. That is one thing I definitely miss as I am working with Unbreakable Linux. I think next time I might try Ubuntu or Fedora just for experimenting around because the repositories are already setup and software installation is easier.