You'll want the Oracle client tools on the SQL server, and then make sure (depending on the version of Oracle) that you have the correct entries in the registry (see http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B280106&nbsp.

Then you'll have to set up the tnsnames entries for the connections. That's it.