It took me half of my working day but at the end I succeded in installing DBD::Oracle Perl module on my Fedora 13, as I spent so much time to find the solution I think it’s worth to share my experience.
Become root and go on.

First of all download the following rpms from Oracle site and install them:

1. oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm
2. oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm
3. oracle-instantclient-devel-10.2.0.4-1.x86_64.rpm

Install compat-libstdc++-33 via:
yum install compat-libstdc++-33

Modify LD_LIBRARY_PATH and ORACLE_HOME using following commands:
export ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client64/
export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client64/lib/

Then run cpan:
perl -MCPAN -e shell

and in it’s shell run the following commands:
install DBI
install YAML
get DBD::Oracle
make
quit

Look at the directory /root/.cpan/build/DBD-Oracle-1.24-xxxxx (mine was: /root/.cpan/build/DBD-Oracle-1.24-Ghl15e) in the output of make, this directory name is important for next step.

Go to the directory /root/.cpan/build/DBD-Oracle-1.24-xxxxx and issue the following commands:
make test
make install

make test will fail connecting to your Oracle server becouse the script use scott/tiger as login/password but if this fails it’s not a problem, go to next step to install.

If you have a RedHat EL4 you can go to: http://ftp.freshrpms.net/pub/freshrpms/redhat/testing/EL4/oracle/ to get your RPMs.