When you replaced the CMOS battery it restet the BIOS settings.
If you are using a USB or wireless keyboard, it may not be detecting it and thus not responding to the press any key. If you can get into the BIOS setup and change the settings, check to see that the RAID boot drive is second (under the CD) in the boot order screen, also make sure the USB setting is set to Legacy or Auto.

If you still can't boot to the CD, try a different CD. You may have a bad disc or drive or cable or ide controller, etc.

You can keep going down the list. Try the simple things first, BIOS settings, make sure the cables didn't come loose...
Start with that and see what happens.
Good luck.