in reply to remote connection to database

This is precisely what things like DBI and DBD::Oracle are for, so yah. See the documentation for DBD::Oracle for more information.
$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);