Installing DBD::Oracle is probably the hardest single module install I've ever done
It being so close to Christmas, here is my Oracle/Perl wishlist:
Things are supposed to get lot easier once Oracle releases the overdue Instant Client SDK (not sure when this will be, though). Then, you can just install a few RPMs and DBD::Oracle should be able to build out of the box, without much fiddling with the build files and parameters.
And things are also supposed to get even more easy with Perl6/Parrot where the DBD::Oracle does not even need a (C) compiler anymore to install, relying on Parrot's cool dynamic library loaders. But here we are not talking about this year's Christmas...