Have you eliminated Apache from the problem set?

My guess is that the Oracle environment+libraries that Apache is set up for do not match what your general Perl uses, or tries to use.

First eliminate Apache from the problem. If that does not help, please tell us how you installed DBD::Oracle with it passing its tests. If it didn't pass its testsuite, why did you install it at all?