Friday, 2 November 2012

EF "The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)"

I will take you with me how to resolve following error that I have recieved through EF

Higher message from EF
The underlying provider failed on Open.

Inner exception message:
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)"

I have found multiple solutions about this problem.

Source1: msdn forum
Source 2: stackoverflow.com


I have checked running services on my local pc and on server.

I have restarted server. No change. Restarting local pc.

This error lead me to error mesage
ora-12560 tns protocol adapter error

I have run command:
lsnrctl stat

with results:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-SEP-2012 11:41
:18

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date                03-SEP-2012 11:14:57
Uptime                    0 days 0 hr. 26 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oracle\product\10.2.0\server\network\admin\listener.ora
Listener Log File         C:\oracle\product\10.2.0\server\network\log\listener.log
 

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TestOrangeDB001.FocusData.local)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Ok and lastly check if database is online.