perl-DBD-Oracle

I am trying to install perl-DBD-Oracle-1.16-1.2.rpm on Suse (SLE 9), like
rpm -Uvh perl-DBD-Oracle-1.16-1.2.rpm but I keep getting the following error message

error: Failed dependencies:
libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.16-1.2.el4
libnnz10.so is needed by perl-DBD-Oracle-1.16-1.2.el4
libocci.so.10.1 is needed by perl-DBD-Oracle-1.16-1.2.el4
libociei.so is needed by perl-DBD-Oracle-1.16-1.2.el4
libocijdbc10.so is needed by perl-DBD-Oracle-1.16-1.2.el4

the above oracle libraries are all available in /u01/app/oracle/product
I set ORACLE_HOME=/u01/app/oracle/product
and LD_LIBRARY_PATH

what are my doing wrough? how do tell rpm were oracle libraries are? can you help please?

Thanks

Can you find the missing libraries indicated in your Oracle installation? But RPM will not honor even if you have it as they are installed manually in "nonstandard" locations.

Why not just install the module manually? According to the README file in DBD::Oracle, you can set the envvar ORACLE_HOME to help locate your Oracle installation: