Check Tnsnames.ora in the server where you have created the database link, does prod exist there?