title: Unable to begin a distributed transaction for linked server from SQL Server to Oracle
body: <p>I have created a linked server from SQL Server 2005 to Oracle 11g. 
  <a href="https://i.stack.imgur.com/sErVb.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>I can select or insert into the table of the linked server by Transact-SQL in Query Analyzer but when I create a trigger in SQL for Insert to Oracle, it shows this error:</p>
  
  <p>"OLE DB provider "OraOLEDB.Oracle" for linked server "BCSS" returned message "New transaction cannot enlist in the specified transaction coordinator. ".</p>
  
  <p>The operation could not be performed because of OLE DB provider "OraOLEDB.Oracle" for linked server "BCSS" was unable to begin a distributed transaction."</p>
  
  <p><a href="https://i.stack.imgur.com/18D0Y.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>I don't know why. Please, help me solve this problem. Thanks!</p>
  
  <p>My trigger:</p>
  
  <pre><code>ALTER TRIGGER [import_test]
     ON  [dbo].[Test123] 
     AFTER INSERT
  AS 
  BEGIN
      DECLARE @eventid  INT
      SET @eventid  = (SELECT ID  FROM inserted) 
      INSERT INTO BCSS..SYSPTTB.EVENTS(EventID) VALUES (@eventid)
  END
  </code></pre>
  
  <p>I have configured MSDTC on both server:
  <a href="https://i.stack.imgur.com/Kgna3.png" rel="nofollow noreferrer">enter image description here</a></p>