Have you got sqlplus connecting to this Oracle yet?

Set ORACLE_HOME env var to point into your oracle tree and export it, run perl Makefile.PL and make and post the output of both here. If the make succeeds, set ORACLE_USERID=username/password and DBI_DSN=dbi:Oracle:host=x;sid=y (or whatever you need to connect to Oracle) and run make test. Post the output here.

It looks as if you have a 32 bit Perl but is this a 32bit machine?