April 6, 2016 at 9:52 am
Last weekend a SQL Server Instance was migrated from WIN2008R2 to WIN2012R2, everything was fine.
We have configured an Linked Server with Oracle10g to retrieve data from a specific system.
Today when the process that uses the linked server run, the following error was thrown [DAO - Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "LINKEDSERVERNAME".]
The problem was solved adding the service account that was associated on linked server as local administrator on WIN2012R2 but
during the troubleshooting, before we find the solution, connections were open like [EXEC sp_testlinkedserver N'LINKEDSERVERNAME'] and when we kill the spid they become with the status KILLED/ROLLBACK following by the wayt_type PREEMPTIVE_COM_QUERYINTERFACE.
Is there any way to kill those connections without restart the SQL server ?
April 6, 2016 at 2:11 pm
You need to find and kill the associated orphaned distributed transactions. Easier said than done.
In this case, the distributed transaction hasn't even started because of the provider error, so I really don't know how to help you. I remember I had the same exact kind of issues when workin with a DB2/400 database and its OLEDB provider. We ended killing DTC and/or restarting the instance, because we could do nothing else.
Good luck!
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply