Finally DBD::Oracle has been recompiled in another directory which is called via use lib before use DBI.

Worth a note is that LD_LIBRARY_PATH needs to include the lib32 directory of Oracle 9i .
This is set via the shell since it does not seem to work when setting it in %ENV, even from within a BEGIN block.

Thanks for all the advice !