I've found if you set ORACLE_HOME in a BEGIN block solves a lot of problems (not just yours).

BEGIN {

    $ENV{"ORACLE_HOME"} = "/home/oracle/OraHome_1";

}

# rest of your code goes here
[download]

Your versions of DBD::Oracle and DBI should work fine with 9i or 10g. At least I haven't had any serious problems with them.