When it says that it can't locate a loadable object for DBD::Oracle, I'm not sure what it's looking for, so I'm having issues verifying that everything did install as expected.

You explained in detail about how you installed DBI but you have not mentioned installing DBD::Oracle. Did you do that? If not, that is what you must do.