Here is problem you may encounter using a Linked Server connecting to an Oracle Database. I was trying to create a table in SQL Server with data from an Oracle database using a Linked Server and I received this error: Unable to enlist in the transaction Msg 7391, Level 16, State 2
Continue reading Unable to enlist in the transaction using a Linked Server. Msg 7391, Level 16, State 2
Jim Salasek's SQL Server Blog 