The connect string that you pass to DBI->connect has to begin with dbi:Oracle, otherwise DBI can't know what driver to load.

The DBD::Oracle has two sections on connecting to Oracle, maybe some of that helps you a bit.

(I'd also recommend to start with simple cases, and once you have a connection, you can start adding a the load balancing stuff).