in reply to How do you connect to a remote Oracle DB using DBI

From that error message I would first look at your tnsnames.ora file before getting into trial and error with the connect string on the script. Here follow a few thoughts: