ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA with Linked Server
most likely this is and issue with the look up for your alias. a quick workaround for is to set the Data Source and Provider Strings to the following:
<FQ hosting name>:<port>/<alias>
thanks to bkgroups<AT>yahoo<DOT>com for the post all the way back in 2007 on sqlmonster.com for the answer.