Thanks Corion!! I was able to get it to work following your previous posts on the topic. Adding this to head of the test:

BEGIN {
    if( ! $ENV{PDUPRE_RESTART}) {
      $ENV{LD_LIBRARY_PATH} = '...some Oracle path../lib';
      #$ENV{DYLD_LIBRARY_PATH} = '...some Oracle path../lib';  #Either
+ LD OR DYLD works
      $ENV{PDUPRE_RESTART} = 1;
      exec $0, '--restarted', @ARGV
    };
};
[download]

worked after I made the test an executable and set the shebang line to point to my local install of perl:

!#/Users/.ME./perl
[download]

I had it set to:

!#/usr/bin/env perl
[download]

but it didn't show up because I am in the habit of running my perl scripts/tests using `perl t/some.t`; if I run using `/usr/bin/env perl t/some.t` than I again get the error from the OP.