You have to get the cloudy mirror by winning the chocobo race at Remiem temple, and then convert it to the celestial mirror at macalania. Once you have that, you'll be able to activate the celestial weapons. I think the walkthrough on this site should have more details about it - hope this helps!
