You need to set some environment variables, either in your environment (d'oh), or directly in Perl:

$ENV{ORACLE_HOME} = ...;
$ENV{OCI_NLS_CHARSET_ID} = ...;
[download]

Or supply both hostname and sid, as mentioned in the DBD::Oracle documentation.