Jon Morisi steps in to show how to set up a linked server connection to an Oracle database:
In this dialog box, the “TNS Service Name” drop down box should display your entries from the tnsnames.ora file. Next, enter your Oracle User ID and click “Test Connection”, at which point you’ll be prompted for your password. Everything should test successfully at this point.
Now would be a good time to restart. Unfortunately, yes you need to restart…
You can do an additional test via sqlplus. Open a windows command prompt and enter the following:
sqlplus user/pass@[addressname](Where addressname is one of your connections from tnsnames.ora)
I readily admit that I’m glad I don’t need to work with Oracle. Nonetheless, if you do need to integrate the two, this step-by-step guide will show you how.